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

2 votes286 views1 answer
Set auto increment from 1
SQL
1 vote266 views1 answer
Oracle apex run 404
SQL
0 vote271 views1 answer
Mysql disable query caching
SQL
2 votes288 views2 answers
Postgres trigger insert into another table
SQL
4 votes260 views3 answers
Create database in mySQL
SQL
22 votes279 views3 answers
SQL CHEATSHEET
SQL
20 votes265 views5 answers
Reset auto increment mysql
SQL
0 vote272 views1 answer
Sql trigger to call stored procedure with parameters
SQL
1 vote283 views2 answers
Oracle difference between two dates in seconds
SQL
0 vote276 views1 answer
Ubuntu connect to mssql database
SQL