sql search all stored procedures for a string code example
Example 1: find string in stored procedure sql server
SELECT name
FROM sys.procedures
WHERE Object_definition(object_id) LIKE '%strHell%'
Example 2: search stored procedures by name
select *
from
sys.procedures
where
name like '%name_of_proc%'