Find All Stored Procedures Containing Text In SQL SERVER

To find stored procedures name which contain search text, write this query and execute.
  1. SELECT OBJECT_NAME(id)  
  2. FROM SYSCOMMENTS  
  3. WHERE [text] LIKE '%type here your text%'  
  4. AND OBJECTPROPERTY(id, 'IsProcedure') = 1  
  5. GROUP BY OBJECT_NAME(id)