SQL query to search text in stored procedures of a database

USE [DatabaseName]
SELECT OBJECT_NAME(object_id),
       OBJECT_DEFINITION(object_id)
FROM sys.procedures
WHERE 
OBJECT_DEFINITION(object_id) LIKE '%SearchText%'

 

Discussion
6 - 1 =
** To prevent abusing comments from publishing, posted comments will be reviewed and then published!
 Mritunjay Kumar
Works at Mindfire Solutions

I mostly work with C#, ASP.NET, MVC, WCF, Web API, Entity FrameWork, MS Sql.

More under this category...
SQL query to list out all tables of a database with rows count, space used
All under this category...