Answers for "search stored procedure in sql server with text"

SQL
3

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%'
Posted by: Guest on June-29-2020
0

search stored procedures by name

select * 
from 
   sys.procedures 
where 
   name like '%name_of_proc%'
Posted by: Guest on October-30-2020

Code answers related to "search stored procedure in sql server with text"

Code answers related to "SQL"

Browse Popular Code Answers by Language