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 2005 Forums
 Transact-SQL (2005)
 Find all DB object reference

Author  Topic 

amitbarkai
Starting Member

19 Posts

Posted - 2010-05-30 : 05:02:02
Hi all
can any one remaind me somthing :)

i knew it before , there is an SP_ function
that gives you a list of all the views storted procedures
and tables that related to it

thanks

Kristen
Test

22859 Posts

Posted - 2010-05-30 : 06:50:30
sp_depends ??
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-05-31 : 04:11:52

or

sys.sysdepends

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -