Lun

dear experts, need scenario i have fact table data follows. product productquantity   productcompnent productcomponentprice a1cycle 100   tyre 10 a1cycle 100   tube 5 a1cycle 100   seat 20 a1cycle 100   chain 30 a1cycle 100   handle 10 a1cycle 100   bell 50 a1cycle 100   break 10 b1cycle 200   tyre 10 b1cycle 200   tube 5 b1cycle 200   seat 20 b1cycle 200   chain 30 b1cycle 200   handle 10 b1cycle 200   bell 50 b1cycle 200   break 10 the fact table linked product dimension (containing product-hierarchy , attribute hierarchy product ) , productcomponent dimension. factcount count measure in measuregroup simple row count in fact. tricky part : prductquantity on product level/grain - meaning total quantity of product.  in above example a1cycle h

we've processed large decision tree model in sql server 2005. when try view tree in mining model viewer, following error:   title: microsoft visual studio ------------------------------ the tree graph cannot created because of following error: 'exception of type 'system.outofmemoryexception' thrown.'. for help, click: http://go.microsoft.com/fwlink?prodname=microsoft%u00ae+visual+studio%u00ae+2005&prodver=8.0.50727.42&evtsrc=microsoft.analysisservices.viewers.sr&evtid=errorcreategraphfailed&linkid=20476 the link provides no other documentaiton on error.   we're using 64-bit sql on dell workstation running xp-64 16gb of memory. view of things aren't close running out of memory. since model processed , error occurs when viewing model, problem visual studio , nont anlaysis services?   thanks in advance.   nick it looks tree has large number of nodes (around 34 000) , viewer has troubles handling many nodes , runs out of

hello. i'm struggling crating following layout: have user control of no particular size (eg. user can give size). on control, there 2 toggle buttons. 1 button stretches across whole control. far fine. now, need other button in center of control on top of other button , half size. how can achieve that? thanks in advance. ondra   set canvas.zindex on 2nd button higher value peers shows topmost (note, container these buttons need not canvas). said "half size" assume meant both width , height. should able data-bind these clr object gets values 1st button's actualwidth/actualheight , divides 2. ps: ordinarily i'd advise bind 1st button's properties property binding isn't supported in silverlight 2. Silverlight  >  Designing with Silverlight

hello everyone,   i installing sql server 2005 developer edition(x86) on windows vista os.   i check pre requistics of sql server installation installed iis fully.   but when install, m getting error as:-   "sql server setup failed execute command server configuration. error [microsoft] [sql native client] [sql server]. file names listed not created. check related errorrs.. refer server error logs , setup logs detailed error information."   so shuld cause , how can overcome error proper installation laptop.   any appreciated.     regards, kaumil(sql server developer) moving setup/upgrade forum. SQL Server  >  SQL Server Setup & Upgrade

hi,   wat meant replication?how  many types of replication?how wil use replication set of technologies copying , distributing data , database objects 1 database , synchronizing between databases maintain consistency. using replication, can distribute data different locations , remote or mobile users on local , wide area networks, dial-up connections, wireless connections, , internet. you have following types, transactional replication merge replication snapshot replication peer peer replication the following links might in getting started replication. http://www.microsoft.com/technet/prodtechnol/sql/2005/mergrepl.mspx http://technet.microsoft.com/hi-in/sqlserver/bb331775(en-us).aspx http://msdn2.microsoft.com/en-us/library/ms151196.aspx http://technet.microsoft.com/en-us/library/ms151818.aspx http://blogs.msdn.com/sqlcat/archive/2007/05/07/sql-server-2005-transactional-replication-benefit-of-using-subscriptionstreams-for-low-bandwidth-high-latency-environments.aspx

i using vs 2015 , there strange behavior wrt incoming changes indicator. let's say: i have class1.method1 in main branch i create new branch main called bugfix i fix bug in bugfix branch i merge changes bugfix merge later on delete (not destroy) bugfix branch. now, incoming changes indicator shows 1 incoming change on class1.method1 in main branch and other methods - branch deletion! while understand "logically" correct, makes indicator useless - show many false positives during course of time... i not want destroy branches or remove branch relationships, delete branches make source control explorer ui clean , indicate there no more work on branch ... michael hi michael,    thanks post. i tested scenario in vs 2015 environment, , received same result. far know that’s design, it’s not bug. we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community fo

we plan deploy microsoft tfs server 2017 high availability 30-50 developers. what microsoft recommend code search placement in high availability scenario (separate server, combine reporting, combine 1 of application server)? thank you. hi roman1974, thank posting here. as page  said: "in cases should consider configuring code search on separate server". think should configure on separate server not on tfs server. since have 30~50 developers, server should have @ least 8gb ram, , disk space should 30% of size of collections indexed. more information, refer above link. best regards limitxiao gao msdn community support please remember click "mark answer" responses resolved issue, , click "unmark answer" if not. can beneficial other community members reading thread. if have compliments or complaints msdn support, feel free contact msdnfsf@microsoft.com . Archi

posted - 12/26/2011 :  04:01:31                   hi, have sql server contains multiple databases each of them in process of implementing full text search. there way create different thesaurus file each db using same language? example db1 use thesaurus1, db2 use thesaurus2 , on... thanks, gil hi gill, i not think there workaround this, except using multiple instances of sql. having same problem, , preventing using thesaurus functionality. even in sql2012 there still no support this. hoped have made possible, 've made solution stopwords. in previous editions of sql stopwords kept in files, , used whole instance. microsoft changed able make/use userdefined stoplists in database.   SQL Server  >  SQL Server Search

hello, tried , doesnt work, started service -t flag on default instance havent been able start -t flag 1400 on named instances.   how can know directory mssql.4 mirror instance??   c:\archivos de programa\microsoft sql server\mssql.4\mssql\binn>sqlservr.exe -t 1400 mirror i tried lucho\mirror, mssqlserver$mirror and doesnt work   thanks   another question have, in documentation says mirroring evaluation purposes , not production environments, suppose mean? msft didnt test mirroring feature enough? if not suppoerted why included..?   microsoft support policies not apply database mirroring feature in sql server 2005. database mirroring disabled default, may enabled evaluation purposes using trace flag 1400 startup parameter. (for more information trace flags, see trace flags (transact-sql).) database mirroring should not used in production environments, , microsoft support services not support databases or applications use database mirroring. database mirroring

hello,  i have created usercontrol:   < usercontrol xmlns= "http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x= "http://schemas.microsoft.com/winfx/2006/xaml" xmlns:d= "http://schemas.microsoft.com/expression/blend/2008" xmlns:mc= "http://schemas.openxmlformats.org/markup-compatibility/2006" mc:ignorable= "d" x:class= "main.shadow" d:designwidth= "640" d:designheight= "480" x:name= "myshadow" > < border cornerradius= "13" borderthickness= "1,1,1,1" borderbrush= "#19000000" verticalalignment= "center" horizontalalignment= "center" > < border cornerradius= "12" borderthickness= "1,1,1,1" borderbrush= "#33000000" > < border cornerradius= "11" borderthickness= "1,1,1,1" borderbrush= "#66000000" >

  i'm working with client and i'm migrating them (poorly designed) access database on sql express 2005 database. user id data in varchar column. i've decided move int- identity column make user id convention easier , less user-intensive (don't ask). here's issue:   the current data in solicitation list table linked donation table, joined via user id. new table is a patron info table linked donation table via user id. i've imported old tables access database , left relationships intact. able move people in solicitation list on new patron table, , they've been assigned int-identity user ids. how move old donation data on new table, (while keeping relationships the patrons intact) without having input 9,000+ records in manually?   is there way convert varchar user id column int-identity, autonumbers, , updates corresponding data in donations table accordingly? hi, i'd go in 2 stepa change each table.. you import data "as is" acce

i facing bizzare situation in sql server ssms shows repeted menus , of keys on keyborad dun work when try edit stored procedure. hi muzafar,   can explained more detailed issues? there error message?   if sql server management studio application keyboard cannot work with, might ssms corrupted, may fix issue repairing or reinstalling ssms.   if there more questions, please feel free ask.   thanks, weilin qiao please remember mark replies answers if , unmark them if provide no help. can beneficial other community members reading thread. SQL Server  >  SQL Server Tools

hi there, we going upgrade tfs 2007 collections tfs 2015.3. need perform required procedures before upgrading tfs 2015.3, please advise ? thanks, sahith sahith hi sahith, thank posting here. i think tfs 2007 mentioned tfs2008, because versions of tfs tfs 2005, tfs 2008 , tfs 2010. direct upgrade tfs 2015 supported tfs 2010 , newer, if on tfs 2008 upgrade tfs 2010 or 2012 first , tfs 2015. before upgrading, make sure backup tfs.  should performing online backups, it’s idea offline backup of app tier data tier.  backup of app tier allows quicker restore should go wrong.  should ask team make sure has checked in code changes before backing up.  ensures people have consistent experience. another concern upgrading – compatibility.  should aware of hardware, os, sql server, project server, , visual studio compatibility. please read requirements , compatibility more information. for upgrade, please see upgrade deployment latest version of tfs details. and here

hi i trying build team build 2012 set of solutions work find using visual studio , devenv.exe command. one of problem is output folder setting in the projects that was configured to specific absolute path!. when use team build msbuild , build behave in different way , doesn't put bineries in same location devenv.exe (visual studio) , in case in absolute folder configured. is there way configure team build (msbuild) work same settings devenv.exe ? especially regarding output configuration in projects under solutions thx, cm consultant the main advantage require .net framework on machines compile projects using msbuild whereas devenv requires visual studio installation. jahangeer Archived Forums V  >  Team Foundation Server - Build and release management

hi all, i posting information believing save someones time. using sql server reporting services 2008 r2, objective generate reports bu connection sql server services 2008 r2. observed below error while trying use 'test connection' in report builder. ' unable connect data source. please verify connection properties , credentials.' 'the connection either timed out or lost .' we exactly don't know reason issue, have accidentally figured out solution issue. (a permutation , combination approach) used qualified domain name ssas server name in 1 environment , used strictly server name(without fqdn) in environment.  both of them working differently in 2 cases, working fine. issue resolved no error.  best regards, paramesh. you can check link solution  http://www.duncansutcliffe.com/?p=18 mark post answer if resolves issue. everything sql server | experience inside sql server - mohammad nizamuddin

hello, i able change workitemid values match organization's work order tracking system's id.  read interesting post alludes can done. ( http://social.msdn.microsoft.com/forums/en/tfsgeneral/thread/89239212-06b7-41a3-aafe-168d8c0593b8 ).  comes caveat emptor there's risk of violating referential integrity. so, following questions , thoughts come mind: how can change in work item id value accomplished? if can done, apparently database field not identity column , application handles assignment of numbers. could microsoft team designed database put in cascading updates & deletes enforce referential integrity?  if not, why not? i'm missing maybe thread fill in blanks. thanks, shapij hi shapij, based on description, seems want organize work items id requirement. i noticed mentioned is my reply in post. mentioned, not recommended manually change default work item id since id field relates several data tables in database. if change one, need change oth

hi all, in 1 of ssis package using cache transformation , created cache file using cache connection manager. when moved package test environment showing error value cannot null. cache file path configured variable , variable have default value(eg: c:\a\b\c.caw , path not exist in test environment) run time variable getting updated correct value. sets delay validation true package raising on-error event. could 1 please me. thanks, anil hi there problem variable value debugging i don't know logic for how finding path store files (it might in sql server directory) if running job check path variable getting during run time exists in server. if thats not case simple debugging in bids put msg box or breakpoint in script task. please mark helpful if helps. sumit bi - integration services SQL Server  > 

is new behavior in cp? will remain release? in silverlight elements auto-generated "initializecomponent" function public...in win8 cp metro elements private. lead lots of code re-write in order reuse silverlight code on metro. want make sure new policy , not fluke in cp. thanks, chris muench, mvp and possible metros styles no longer allow dashes in key name? i.e: <fontfamily x:key="c-labsfont">tahoma</fontfamily> in resource directory chris muench, mvp Archived Forums T-U  >  Tools for Windows Store apps (archived)

i have inherited vs 2005 database table has column of type image.  need change image 1 of rows in table. have new image in *.png file on c: drive.  correct method inserting file image column. many thanks! hi andrea, have here: http://forums.microsoft.com/msdn/showpost.aspx?postid=622943&siteid=1 hth, jens suessmeyer. --- http://www.sqlserver2005.de --- SQL Server  >  Getting started with SQL Server

hi all, when cal following codes teamfoundationserver server = teamfoundationserverfactory.getserver(servername); workitemstore store = (workitemstore)server.getservice(typeof(workitemstore)); a security exception has been thrown. how can authenticat with special user or let server's iusr_myservername has right. thanks.   stack trace: [securityexception: tf50309: not have sufficient permissions perform operation.]    microsoft.teamfoundation.proxy.bisregistrationproxy.getregistrationentries(string toolid) +55    microsoft.teamfoundation.proxy.bisregistrationservice.refreshmemorycache() +83    microsoft.teamfoundation.proxy.bisregistrationservice.refreshcachesifneeded(boolean direct) +75    microsoft.teamfoundation.proxy.bisregistrationservice.getregistrationentries(string toolid) +15    microsoft.teamfoundation.workitemtracking.client.workitemstore.getmiddletierurls(string& serverurl, string& configurationsettingsurl) +62    microsoft.teamfoundation.workitem

what i want load pictures flickr, , display them in order. have used array hold pictures , display them 1 image displayed, think last 1 not totally sure. have used femy extension buttons. the code program sfx646. a couple of things here: 1] call flickr getting url, not image - try following download image well: dpic[dpc]=imagelist.loadimage(flickr.getrandompicture("snow")) 2] not sure graphicswindow updated regularly in button event - perhaps feature of way coded in extension - may wrong looks way, set flag in event code , handle in main loop. 3] takes time download (if don't in point 1 above) , draw resized image may not update 1 image before next being displayed - lengthen program.delay in display sub. here put together. sfx646-0 Learning  >  Small Basic

hi all, i'm looking advice, we have 3 instances of sql server 2008 on server 1 each having own rs instance installed, have server (server 2) 3 more instances of rs installed pointing @ reportserver of sql instance on server 1. so multi tier rs instances on multi boxes scale out deployment. we seem having difficulty around getting 3 instances of rs on server 2 work. have had them working on own spn's applied/not applied kerberos enabled/disabled. we struggling 3 instances on server 2 work @ same time. i've been having read , come rswebapplication config , mention of pointing particular instance of rs report server.   if has advice appreciated. andy great question, wrong forum.  try http://social.msdn.microsoft.com/forums/en-us/sqlreportingservices/threads russel loski, mct SQL Server  > 

hello, i have created ssis packages on local machine, want deploy them dev, test , production servers. know how deploy them, but want someone to help me changing connection manager in packages. servers have same database names, should change connection manager match their respective servers can executed , data can loaded in them. sree hi , for should use ssis configuration option during deployment . otherwise have option open package again in bids changes connection , deployment. i'll suggest use configuration file connection manager. http://www.mssqltips.com/sqlservertip/1405/sql-server-integration-services-ssis-package-configuration/ thanks please mark answer or vote helpful post if helps solve question/problem. http://techequation.com SQL Server  >  SQL Server Integration

i trying export ssrs report has more 65k rows excel. there any way can export selected view excel instead of exporting rows (just when exporting pdf)? hi amscfg, based on researching, this is design, means not able export drill-down part excel as mentioned currently.   to work around issue, add action of jumping report subreport. design subreport display drill-down part, , export subreport excel. more information how to: add drillthrough action on report (reporting services) http://msdn.microsoft.com/en-us/library/ms159847.aspx hope helps. regards, challen fu SQL Server  >  SQL Server Reporting Services, Power View

in v1.2 ctp version, databasemetadata methods getting information objects in database (i.e. gettables(), getcolumns(), ...) errors if current database connection in different database object quering.  is intended behavior going forward? in case have access both database , database b.  current connection in database , looking object in database b.  resultset rs = conn.getdatabasemetadata.gettables("b","dbo","%",{"tables" });     [junit] database name component of object qualifier must name of current database.     [junit] com.microsoft.sqlserver.jdbc.sqlserverexception: database name component of object qualifier must name of  the current database.     [junit]     @ com.microsoft.sqlserver.jdbc.sqlserverexception.makefromdatabaseerror(unknown source)     [junit]     @ com.microsoft.sqlserver.jdbc.sqlserverstatement.getnextresult(unknown source)     [junit]     @ com.microsoft.sqlserver.jdbc.sqlserverstatement.doexecutestatement(unknown source)    

i found silverlight , windows phone not compatible web api/pcl combination.   are there plans make them compatible. hi, for use web service in c# in silverlight. here article talked this,please have  see: http://www.kastory.net/index.php?option=com_content&view=article&id=25:rest-web-service-in-c-with-silverlight-and-asp-net-web-api&catid=32&itemid=130 best regards, we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community forums great place. click here participate survey. Silverlight  >  Silverlight 5

hello, i have admit bad sql. have scenario 1 of tfs 2015 view stores team project name guid which is of type nvarchar. need provide users name of projects rather id in report. have view in tfs 2015 gives me name of projects. thought of writing join statement 2 views , project names. went below query , keep on same page, team project name in first view has guid , name well. older projects migrated tfs 2012. system.teamproject has team project name (older project name tfs 2012) , id new projects (tfs 2015). in short has names , id's stored in it. want names output in report to further report set up. select * [dbo].[vw_denorm_workitemcorelatest] wi inner join [dbo].vw_projects p on wi.[system.teamproject] = p.project_id union all select * [dbo].[vw_denorm_workitemcorelatest] wi inner join [dbo].vw_projects p on wi.[system.teamproject] = p.project_name for have * in query. know second part of query works fine , return data projects has name stored.  however guid id

hi i'm relatively new mdx after many years doing sql. i've run business challenge in our cube relating called daily sales outstanding (dso). challenge when given debt amount in given point in time, have count each day, summing billed amounts per day until reach debt amount started with. i.e should tell many days of billing takes reach our debt amount. see example below: current debt = 5000 day [n]           billed amount  cumulative amount day 1            1200                 1200            (although i've started @ day 1, in date terms start @ recent day                                                             , count backwards in time) day 2              1000               2200 day 3              1500              3700 day 4             1000               4700 day 5             800                5500 <--- debt amount reached on day 5, hence figure i'm after in example "5" day 6 day 7 i've googled around , there coupl

hi i have managed install sql server 2012 (for first time) skipping on analysis services step keeps giving me error message data directory file path being invalid, though using default root directory. the installed functionality using default directory without errors, when go setup install ssas still keep getting error "the folder path specified invalid". i've spent day searching online solution found people same problem , no genuine fix. know workaround issue please? thanks help. kathy thanks pituach i checked log file , found problem mofcomp compatibility. cheers kathy SQL Server  >  Getting started with SQL Server

hi. can user db owner permission generate scripts of objects data of contained database in sql server 2012 ? mark answer if reply helpful<br/> thanks<br/> neeraj bhandari (mcts - sql server 2008) you can include in schema & data option by clicking advance button in scripting task, refer http://blog.sqlauthority.com/2011/05/07/sql-server-2008-2008-r2-create-script-to-copy-database-schema-and-all-the-objects-data-schema-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/ SQL Server  >  SQL Server Tools

http://labs.componentone.com/sapphire/  i haven't had time use components, played samples , i'm amazed how have accomplished sl 1.1 alpha. samples run clean , solid. now here thoughts: a) msft in middle of revamping sl 1.1. alpha version demonstrate small part of real 1.1. have no doubts many of current namespaces , class hierarchy broken in next release , many new ones added. so, feel safe develop application based on current sl alpha , sapphire alpha? b) wait msft introduce 1.1 , components come it, use in application or jump on third party components building app? c) how guys willing pay above components? let brainstorming begin...  just downloaded , start playing it.  have high expectations.  c1 & infragistics have served me well.   a.) sure.  happened lot .net , never required ton of work correct old code. b.) love ms, they've been paying bills 10 years, have had poorly featured controls compared c1 & infra.  don't think differen

hi all, is there ways can use store procedure (not via ui) commit version , create(copy) new 1 version?? thanks in advance. br, jackie i udpversioncopy stored proc. or other updversion* procs. also while looking udpversioncopy info found post might of interest you: http://social.msdn.microsoft.com/forums/sqlserver/en-us/17f80469-5b2b-40ae-baad-dfa05488ce81/versioning-mds-model-within-a-visual-studio-solution?forum=sqlmds SQL Server  >  SQL Server Master Data Services

  hi will restricting log file size of database affects mirroring???. since our databases on simple recovery model. have every day bulk inserts. time our log file didnt increased much. did mirroring on particular database.. notice log file size tremendously increasing.. planned restrict size of log file. affects mirroring. please me out... hi santhosh, full recovery model 1 of prerequisite configuring database mirroring. in simple recovery model log file automatically truncated. in full recovery model dbs involved in mirroring need take regular transaction log backups every 30 mins log truncated , wouldn't grow abnormally. please not restrict log file size unless sure log wouldn't grow beyond size since operations such has bulk insert may fail might not able grow beyond size.. - deepak SQL Server  > 

i gonna need advice. if gonna create star schema, measurement in relation cash flow should create in fact table? in addition, if have advice dimenision table should use, great hear. what i'm doing updating skills. i moving ssas. kalman toth database & olap architect sqlusa.com new book / kindle: pass sql exam 70-461 & job interview: programming sql server 2012 SQL Server  >  SQL Server Analysis Services

my task simple explain: need programmatically information user can see if goes in vs cube designer -> dimension usage tab, i.e. relations between measure groups , dimensions. can make user in management studio right-click cube , select "script cube as"->"create to", put result xmla-script t-sql-script, that, using xquery, retrieve information relations. these scripts:   select  nref.value('../../../../../../../id[1]', 'nvarchar(50)') measuregroup, nref.value('../../../../../cubedimensionid[1]', 'nvarchar(50)') dimension, nref.value('tableid[1]', 'nvarchar(50)') tablename, nref.value('columnid[1]', 'nvarchar(50)') columnname @xvar.nodes('//measuregroups/measuregroup/dimensions/dimension/attributes/attribute/keycolumns/keycolumn/source') r(nref) -- list of dimension - attempt key fields: select  nref.value('dimensionid[1]', 'nvarchar(50)') dimension @

i know printing not supported silverlight (why?) , i'm looking way enable app... what need print canvas number of controls can dynamically added, dragged , dropped etc. default file->print in browser (ie) results in canvas being scaled in nasty way. how can print canvas , not lose quality drastically? is there way this? maybe convert image somehow? you can convert canvas image using writeablebitmap. need upload image server , use on page print. there article @ silverlight show explaining in more details how this. http://www.silverlightshow.net/news/printing-in-silverlight-3-with-writeablebitmap-.aspx Silverlight  >  Getting Started with Silverlight

hi, investigating requirement client implement fine grained ssas security roles, have 10 cubes bound global active directory groups. for example, current ad groups bi_sales, bi_orders, bi_inventory (and on). these bound ssas cubes (sales, orders, inventory), each group holding data @ global level (across around 10 countries). i need implement security country , business vertical, , have dimensions set these, , coding users dimension also. however, concerned sustainability of security model, have 10 countries , 7 verticals. if grows, there sharp increase in number of ad groups. concerned sheer number of ad groups individual user allocated to, potentially slow down user access network, or @ best provide headache dba need support security model in future. i looking ideas can improve flexibility , sustainability of model, if 1 has experienced type of architecture please let me know ! thanks in advance, david are users in sql table, along countries , verticals permit

i getting error on data collector (non-cached) task in sql server 2014. here highly appreciated. executed user: xx. ssis error. component name: dft - collect query 0, code: -1071636471, subcomponent: ole db source [14], description: ssis error code dts_e_oledberror.  ole db error has occurred. error code: 0x80004005.    an ole db record available.  source: "microsoft sql server native client 11.0"  hresult: 0x80004005  description: "the metadata not determined because statement 'exec (@sql)' in procedure 'schemaauditddltrigger'  contains dynamic sql.  consider using result sets clause explicitly describe result set.".   ssis error. component name: dft - collect query 0, code: -1071636406, subcomponent: ole db source [14], description: unable retrieve column information data source. make sure target table in database available. ssis error. component name: dft - collect query 0, code: -1073450982, subcomponent: ssis.pipeline, description: ole d

hi i doing task synchronize data between sql server 2005 , sql mobile. created publication in sql server 2005 created subscription in device thru coding. code below. sqlcereplication repl = null ; try { repl = new sqlcereplication (); repl.interneturl = @"http://localhost/testfirst/sqlcesa30.dll" ; repl.publisher = @"zcs6" ; repl.publisherdatabase = @"testnow72743" ; repl.publishersecuritymode = securitytype .dbauthentication; repl.publisherlogin = @"sa" ; repl.publisherpassword = @"test" ; repl.publication = @"testfirst" ; repl.subscriber = @"testnow7274310" ; repl.subscriberconnectionstring = @"data source = '\testfirst.sdf';" ; if (! file .exists( @"\testfirst.sdf" )) repl.addsubscription( addoption .createdatabase); repl.synchronize(); } catch ( exception ex) { messagebox .show(ex.message); } finally { repl.dispose(); } i

so have number of separate databases on sql 2005 server. i have number of reports in ssrs. many of stored procedures in various databases reference tables, functions, , stored procedures in other databases on same server. how can accomplish effect of right clicking on stored procedure instance, clicking view dependencies, , having show in list, not items in db? it stored in database in 1 form or another, must missing crucial piece integrating together. note: did not design system, maintaining , modifying existing items. there no schemas speak of. ssrs move dedicated server @ 1 point other data warehousing functions, ability span servers useful. thanks! matt hi, jens correct.   there lot of confusion "sysdepends", we've added new section explaining sql dependencies in web refresh section of bol.   please read: sql server 2005 books online  understanding sql dependencies  new: 5 december 2005 http://msdn2.microsoft.com/en-us/library/ms345449.asp