SP to search String in TEXT of SPs

• Prasad Bhogadi

  SSCrazy Eights

  Points: 9235

  More actions

  October 1, 2007 at 8:27 am

  #181769

  Comments posted to this topic are about the item SP to search String in TEXT of SPs

  Prasad Bhogadi
  www.inforaise.com

• gbobrowski-968732

  Grasshopper

  Points: 13

  More actions

  May 11, 2009 at 10:23 am

  #992291

  On SQL server 2005 it could be just that:

  SELECT ROUTINE_NAME, ROUTINE_DEFINITION

  FROM INFORMATION_SCHEMA.ROUTINES

  WHERE ROUTINE_DEFINITION LIKE '%whateverstringyouneedtofind%''

  AND ROUTINE_TYPE='PROCEDURE'

  Greg from Moxy Media in Guelph