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

1 vote373 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
1 vote368 views1 answer
Mysql curdate between two dates
SQL
0 vote378 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote331 views1 answer
Sub blocks in sql
SQL
2 votes327 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
0 vote1.2K views1 answer
Mysql custom sort order
SQL
0 vote380 views2 answers
Temp tables in sql server
SQL
0 vote354 views2 answers
Postgres show current role
SQL
49 votes398 views6 answers
Alter table add column
SQL
1 vote332 views1 answer
Sql get all columns from one table but one from another inner join
SQL