Never been to DZone Snippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

About this user

Mark Easton

« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS 

Search for specific text in all stored procedures

declare @search varchar(50)
SET @search = 'searchterm'

SELECT    
     ROUTINE_NAME,
     ROUTINE_DEFINITION
FROM    
    INFORMATION_SCHEMA.ROUTINES
WHERE    
    ROUTINE_DEFINITION LIKE @search
ORDER BY
    ROUTINE_NAME
to sql sql-server SQLServer SQL Server by mrtrombone on Apr 25, 2007 1 Comments
« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS