Group: Forum Members
Posts: 2K,
Visits: 6.6K
|
Check out sp_depends and if you have SQL Server 2005, sys.sql_dependencies. Search for dependencies in SQL Server help, for just T-SQL too.
What I've done in the past is open up the system sproc (found in master db), then copy the code to my own sproc/script/view and mess with it as needed. I don't ever mess (obviously) with the system sproc. Also note that hitting system tables is not guaranteed to work between versions (i.e. there is no guarantee that the information you are getting out of a system table in sql 2000 will be the same in 2005, or that the table will even exist). They usually provide system views that are though.
|