Tuesday, 12 January 2016

MS SQL Server - Search for string in all stored procedures

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