Searching in Text of all store Proc in a database
Some time you might be in need , or you will be putted in such a condition where you have large store proc and those store proc are internally calling so many store proc and those store proc again calling so many store proc , and when you want to find out a particular store proc is called form which store proc.
In Short i want to let you know that if you want to search the text of all store proc for a particular sp in a database, you can do this by simple tricky code.
select id from syscomments
where text like '%function name or sp name to search%'
select * from sysobjects where id in (id1,id2)
In Short i want to let you know that if you want to search the text of all store proc for a particular sp in a database, you can do this by simple tricky code.
select id from syscomments
where text like '%function name or sp name to search%'
select * from sysobjects where id in (id1,id2)
