Search Text In Stored Procedure In SQL

Arun Kumar

10y640Code

Thsi code snippet shows how to Search Text in Stored Procedure in SQL.

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 '%MyStoredProcedureName%'