1. Code Snippets
  2. SQL
Published by Mritunjay Kumar, Mindfire Solutions, about 1 year ago.
   
625 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 1 year ago     550 Views
All under this category...