sql server search text of stored procedures code example
Example 1: search text in all sql server stored procedure
SELECT OBJECT_NAME(object_id)
FROM sys.sql_modules
WHERE OBJECTPROPERTY(object_id, 'IsProcedure') = 1
AND definition LIKE '%Foo%'
Example 2: search stored procedures by name
select *
from
sys.procedures
where
name like '%name_of_proc%'