Return to Snippet

Revision: 29920
at August 5, 2010 05:31 by lance


Initial Code
--needs to be run in the database that you want to search in
--get all procedures with name like
   SELECT Distinct SO.Name
   FROM sysobjects SO (NOLOCK)
   WHERE SO.Type = 'P'
   AND SO.Name LIKE '%report%'
   ORDER BY SO.Name


--get all procedures containing text like
   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 '%report%'
   ORDER BY SO.Name

Initial URL


Initial Description


Initial Title
Find Stored Procedures with specified name or contains specified text

Initial Tags
sql, search

Initial Language
SQL