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 vote131 views1 answer
Createdb with postgresql on ubuntu
SQL
3 votes133 views1 answer
Oracle user quota on tablespace
SQL
0 vote130 views1 answer
Grant privileges mysql to database 1064
SQL
0 vote131 views1 answer
Create column that already exists mysql
SQL
14 votes121 views3 answers
Delete all records from table except sql
SQL
5 votes126 views1 answer
Sql add column after another
SQL
7 votes124 views2 answers
What is sql clause
SQL
1 vote125 views1 answer
Access the postgres psql
SQL
1 vote133 views1 answer
Check if mysql is installed
SQL
1 vote132 views2 answers
Backup table mssql
SQL