Question : search text in all sql server stored procedure
Answered by : inexpensive-iguana-n9e7iaypmuwz
SELECT OBJECT_NAME(object_id) FROM sys.sql_modules WHERE OBJECTPROPERTY(object_id, 'IsProcedure') = 1 AND definition LIKE '%Foo%'
Source : https://stackoverflow.com/questions/5079457/how-do-i-find-a-stored-procedure-containing-text/26467021 | Last Update : Mon, 06 Jul 20
Question : search stored procedures
Answered by : impossible-iguana
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]%';
Source : | Last Update : Thu, 05 Dec 19