CREATE proc sp_Find_in_Proc
@SeachString varchar(255) = NULL
AS
IF  @SeachString is Null
   Begin
    Print 'Missing Parameter @SeachString!'
    return
   end
 

DECLARE @Pattern as varchar(255)
SELECT @Pattern = '%"' + @SeachString + '%'
Print '  '
Print 'Seaching for ' + @Pattern + ' in procedures....'
Print '  '
Print ' Found in procedures...'
SELECT name FROM syscomments,sysobjects
  WHERE OBJECTPROPERTY(sysobjects.id,N'IsProcedure')=1
   And sysobjects.id = syscomments.id
   AND PATINDEX(@Pattern , text) !=0
   ORDER BY Name