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.
| Author |
Topic |
|
saustin
Starting Member
1 Post |
 Posted - 2007-05-15 : 04:46:15
|
| Morning,New to this, so sorry if this is a basic thing...I need to find where a certain stored procedure is being called within the database.is there anyway to do this ?Many thanks |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-05-15 : 08:56:54
|
| Run sp_who or sp_who2MadhivananFailing to plan is Planning to fail |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-15 : 09:04:10
|
| Do you want to see dependencies (or kinda call stack) for this SP?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
cvraghu
Posting Yak Master
187 Posts |
Posted - 2007-05-15 : 13:03:57
|
| The text for stored procedures are stored in syscomments table. You can query the 'text' column on this table to find out whether any other procedure is calling the specific procedure. |
|
|
|
|
|
|
Locating where a stored procedure is run