MS SQL: Find Text in Function or Stored Procedure Definitions

Modified on Wed, 19 Nov at 7:48 PM

SELECT 
    o.name AS ObjectName, 
    o.type_desc AS ObjectType
FROM sys.sql_modules m
INNER JOIN sys.objects o ON m.object_id = o.object_id
WHERE m.definition LIKE '%****StringToSearch****%'