Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Search For Specific Text In All Stored Procedures

DZone's Guide to

Search For Specific Text In All Stored Procedures

· ·
Free Resource

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
Topics:

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}