search-stored-procedures.md

SEARCH FOR TEXT WITHIN STORED PROCEDURES

Description

Often you'll want to know which stored procedure is performing an action or contains specific text. Query will match on comments.

Snippet ✂️

SELECT name
FROM   sys.procedures
WHERE  Object_definition(object_id) LIKE '%strHell%'

Usage

SELECT name
FROM   sys.procedures
WHERE  Object_definition(object_id) LIKE '%blitz%'

name
sp_BlitzFirst
sp_BlitzCache
sp_BlitzWho
sp_Blitz
sp_BlitzBackups
sp_BlitzLock
sp_BlitzIndex

Referenced

Stackoverflow