September 30, 2009 at 2:25 pm
Hi,
I have written a set of 3 stored procedures. And each of the SP will be used in different set of SPs.
Is there any command that gives the reference sp list for a given SP?
thanks in advance..
-Suneel
October 1, 2009 at 2:14 am
See BOL ---> Understanding SQL Dependencies
October 1, 2009 at 2:35 am
The commands you can use for dependencies are
sp_depends
sys.dm_sql_referencing_entities
sys.dm_sql_referenced_entities
If you look these up in BOL, it will give you more information
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply