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 |
|
wided
Posting Yak Master
218 Posts |
 Posted - 2010-03-08 : 06:43:18
|
| helloi'm sorry, i can't write english very wellI have many stored procedures, il want to find one procedure called in several other proceduresthanks |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2010-03-08 : 10:05:04
|
Its like looking for landmines after the war is over or mouse traps in a dark old house  |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-08 : 10:30:02
|
use sp_depends or SELECT * FROM sys.sql_modules WHERE definition LIKE '%' + @yourprocname + '%' AND OBJECT_NAME(object_id) <> @yourprocname ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
stored procedures