Friday, September 24, 2010

TSQL Search in text in stored procedure

SELECT Distinct SO.Name
FROM sysobjects SO (NOLOCK)
INNER JOIN syscomments SC (NOLOCK) on SO.Id = SC.ID
AND SO.Type = 'P'
AND SC.Text LIKE '%SuspendS21%'
ORDER BY SO.Name

No comments: