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

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

1031 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

5 X 6 =

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

All under this category...