InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 05:00:47 GMT20http://www.sqlservercentral.com/Forums/Topic952928-8-1.aspxI've recently been looking at a similar problem - approximately 25 databases all with links into other databases, and we can't upgrade them all to 2008 at once. sp_depends is not accurate enough when dealing with objects in other databases, or via linked servers.Our solution has been to restore all databases into a development 2008 environment and query the new sys.sql_expression_dependencies view. It's not perfect, as Lowell mentioned, as it can't detect dynamic SQL, but it's a lot better than the 2000 version of sp_depends.Thu, 15 Jul 2010 05:05:30 GMTJim McLeodhttp://www.sqlservercentral.com/Forums/Topic952928-8-1.aspxsp_depends is 100% accurate for tables functions and views. you cannot create any of those things with a dependency to another object unless the object exists.because of the way procedures are allowed to be created, it can be incorrect for procedures if 1: the proc was created BEFORE the objects it uses were created. 2. the proc uses dynamic SQL.if you recompile your procedures, you can fix #1 as the ALTER PROC syntax will put the dependencies back in for you if they were missing, but there's no way i know of to accurately get dynamic sql dependencies.Thu, 15 Jul 2010 04:55:17 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic952928-8-1.aspxDear All,Please help me to find the dependencies of an database object across all other databases. I am using SQL 2000. I have selected an object from one database. I want all dependent object of this selected object among all databases and also the list of objects which the selected object is dependent to.Is it okay trusting SP_Depends? It seems not giving correct answer.RegardsThu, 15 Jul 2010 02:57:48 GMTiam777here4u