Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 dependancies

Author  Topic 

gavakie
Posting Yak Master

221 Posts

Posted - 2007-09-28 : 17:03:51
I am using ths (Exec sp_depends Table_Name) to find what views and stored procedures run off that table. How do I go to the second level. From ther I want to see what else are being used from what i found from the first exec statement.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-28 : 23:00:45
Exec sp_depends object_Name, replace object_Name with whatever you got in first run.
Go to Top of Page
   

- Advertisement -