![Find text in Stored Procedures](https://www.mike250.com/c/m/shutterstock_590074937-786x436.jpg)
Find text in Stored Procedures
I can’t express how useful this has been to me when trying to find whether a text string exists in one of our Stored Procedures / Functions:
DECLARE @value VARCHAR(50) = 'getPrice'
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 '%' + @value + '%'
Leave a comment