Find Any Content From Stored Procedures In SQL SERVER

in this blog, find any content from procedure to checking the impacted procedure list.

Execute the below Query to get the Impacted Object list

DECLARE @Content NVARCHAR(4000)='Single'

SELECT s.name,sc.text FROM SYS.OBJECTS s JOIN
SYS.SYSCOMMENTS sc on sc.id=s.object_id
WHERE sc.text LIKE '%' + @Content + '%'

Output

Thank you for reading my blog.