Search text from all stored Procedure in One Database

The following stored procedure will list all stored procedure names whose text contains the parameter search string.


CREATE PROCEDURE Find_Text_In_SP
@StringToSearch varchar(100)
AS
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

--exec Find_Text_In_SP 'vWgetuser'
--find view name from all stored procedure in database