Search For String In Stored Procedures

Ever needed to find a stored procedure with a specific string in it? You can pretty this up as a stored procedure and pass it a parm or cut and paste it into query analyzer.

select name from sysobjects
where id = (select id from syscomments
where text like '%like%')


Edit:

The above works only for a single hit. For multiple hits, this works

select name from sysobjects as A
join syscomments as B
on (text like '%cursor%')
where A.id = B.id

Live and learn,

Cat



Edited by - cat_jesus on 08/22/2001 10:09:49

Edited by - cat_jesus on 08/22/2001 10:10:29