Answers for "sql server serach all sps for string"

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

SELECT DISTINCT
       o.name AS Object_Name,
       o.type_desc
  FROM sys.sql_modules m
       INNER JOIN
       sys.objects o
         ON m.object_id = o.object_id
 WHERE m.definition Like '%[ABD]%';
Posted by: Guest on November-28-2019

Code answers related to "sql server serach all sps for string"

Code answers related to "SQL"

Browse Popular Code Answers by Language