Sql Find Text In Sp

Source URL: https://stackoverflow.com/questions/14704105/search-text-in-stored-procedure-in-sql-server

Language: sql

Created on: 2021-09-08 11:51:06

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]%';
I want to search a text from all my database stored procedures. I use the below SQL: SELECT DISTINCT o.name AS Object_Name, o.type_desc FROM sys.sql_modules m INNER JOIN ...
content_copy