eZeeNow.com

it's your's

Search Text in Stored Procedure in SQL Server

How to search/find text in Stored procedure.

Method 1:

SELECT DISTINCT o.name AS Object_Name,o.type_desc FROM sys.sql_modules m 
INNER JOIN sys.objects o ON m.object_id=o.object_id
WHERE m.definition Like '%[ABD]%'

Method 2:

SELECT Name FROM sys.procedures WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%Employee%'
Loading