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 |
|
johnsql
Posting Yak Master
161 Posts |
 Posted - 2008-05-27 : 14:19:33
|
| Hi experts, Is there someway in SQL Server 2000 to list all stored procedures that depend/use a sepcific stored procedure? For example, if a specific stored procedure named "abc". There are 2 other stored procedures named "lmn" and "xyz" that call sp "abc", I'd like to list names of SPs "lmn" and "xyz".Thank you in advance. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-27 : 14:22:37
|
| check sp_depends on BOL. |
 |
|
|
johnsql
Posting Yak Master
161 Posts |
Posted - 2008-05-27 : 15:25:56
|
quote:
Originally posted by sodeep
check sp_depends on BOL.
Thank for your reply. However, I am afraid that sp_depends abc gives me all tables, columns that my specific stored procedure "abc" depends on but not are list of SPs that depend on the "abc" store procedure.Is there any real way to do my problem? |
|
|
|
johnsql
Posting Yak Master
161 Posts |
Posted - 2008-05-28 : 09:21:46
|
| Please help. Thank you very much.johnsql |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-28 : 10:35:22
|
| Have a look at sysdepends in books onlinehttp://msdn.microsoft.com/en-us/library/aa260402(SQL.80).aspx |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-28 : 20:57:24
|
| Actually you right click SP -View dependencies. There are two options1) objects that depend on SP2) objects on which SP depends.Or sp_depends 'yourSP' (check out for SP) |
|
|
|
|
|
|
how to view all stored procedures depend on an sp