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.