SQL query to search text in all stored procedures of a database

Published by Mritunjay Kumar, Mindfire Solutions, about 2 years ago.

845 Views

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 X 9 =

** 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

Published by Mritunjay Kumar , Mindfire Solutions, about 2 years ago 701 Views

All under this category...