SQL find text in SP

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]%';

Source: stackoverflow.com

Similar codes

0 vote195 views1 answer
Oracle db get table sizes
SQL
0 vote225 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
0 vote207 views1 answer
Tsql cmd exec script from file
SQL
16 votes209 views2 answers
Oracle ddl
SQL
1 vote207 views1 answer
Duplicating a MySQL table with all the data Command
SQL
0 vote210 views1 answer
Setval in postgres
SQL
0 vote204 views1 answer
Oracle SQL join three tables and group by column
SQL
1 vote203 views1 answer
Tsql random number
SQL
1 vote215 views1 answer
Sql server loop over query
SQL
7 votes232 views2 answers
How to create index mysql
SQL