Post reply

SP to search String in TEXT of SPs

  • 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

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply