Wednesday, July 21, 2010

MS Sql Server Stored Proc Search Query

If you work in an org where there's a lot of business logic put into (MS Sql Server) stored procedures or you have an application that is stored proc intensive, you might find this code snipped helpful.  It searches all the stored procs in the database for a specific string

select distinct from syscomments c
inner join sysobjects o
on =
where o.type = 'p'
and c.text like '%string to search for%'
order by

No comments: