List of SP's including search text
List of SP's including search text.
Last updated:
Warning: Review and test in a non-production environment before running.
select distinct 'DATABASE_NAME' DBname, object_name(id) 'procedure' from syscomments where text like '%SEARCH%' order by 1;