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 vote154 views2 answers
Dumping sql table
SQL
103 votes343 views1 answer
Like sql
SQL
0 vote141 views1 answer
1 column values in to 1 single row in sql
SQL
6 votes150 views1 answer
SQL insert all columns
SQL
0 vote150 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
1 vote136 views1 answer
Update from table tsql
SQL
0 vote143 views1 answer
Compare subqueries oracle
SQL
2 votes134 views1 answer
Sql server find table name
SQL
0 vote148 views1 answer
Sql min
SQL
0 vote148 views1 answer
List in one column mysql
SQL