Find stored procedure

DECLARE @StringToSearch varchar(100)
SET @StringToSearch = ‘Bank’

SET @StringToSearch = ‘%’ +@StringToSearch + ‘%’
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 @StringToSearch
ORDER BY SO.Name
GO

Advertisement