search for a string in all stored procedures of sql server database 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: find string in stored procedure sql server

SELECT name
FROM   sys.procedures
WHERE  Object_definition(object_id) LIKE '%strHell%'

Example 3: search stored procedures by name

select * 
from 
   sys.procedures 
where 
   name like '%name_of_proc%'

Tags:

Sql Example

Related