Home Forums Article Discussions Article Discussions by Author Discuss content posted by Mani Singh Search for a String in all Stored Procedures and beyond? RE: Search for a String in all Stored Procedures and beyond?
richard.jereb
SSC Veteran
Points: 208
More actions
October 27, 2011 at 5:23 am
#1400067
Hi, here a further alternative:
select
object_name(object_id) as Name
from
sys.sql_modules
where
definition like '%your_string_comes_here%'
order by
Name
In combination with sp_foreachdb this one can also do the job.
Cheerio, R.