Code Snippets

SQL Code Snippets using SQL Server 2005 - searching stored procedures

  1. 4/9/2010 1:12:33 PM by Eric

    Search Stored Procedure Text SQL Server 2005/08

    SELECT ROUTINE_NAME, ROUTINE_DEFINITION 
    FROM INFORMATION_SCHEMA.ROUTINES 
    WHERE ROUTINE_DEFINITION LIKE '%YOUR_TEXT_HERE%' 
    AND ROUTINE_TYPE='PROCEDURE'

View Sitemap