Question : SQL find text in SP
Answered by : selfish-shrike-fq89l0f52hyl
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 : https://stackoverflow.com/questions/14704105/search-text-in-stored-procedure-in-sql-server | Last Update : Wed, 15 Sep 21
Question : SQL Find text in SPs
Answered by : kevin-tsumuradare
SELECT OBJECT_NAME(id) FROM SYSCOMMENTS WHERE [text] LIKE '%Foo%' AND OBJECTPROPERTY(id, 'IsProcedure') = 1 GROUP BY OBJECT_NAME(id)Source : | Last Update : Mon, 23 May 22