The TSQL Script below will search all SPs within a database for MySearchString.
SELECT obj.Name SPName, sc.TEXT SPText
FROM sys.syscomments sc
INNER JOIN sys.objects obj ON sc.Id = obj.OBJECT_ID
WHERE sc.TEXT LIKE '%' + 'MySearchString' + '%'
AND TYPE = 'P'
GO
No comments:
Post a Comment