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 vote236 views1 answer
Sql server information_schema temp tables
SQL
0 vote227 views1 answer
Mysql drop multiple tables at once
SQL
0 vote271 views1 answer
Distance calculator from lat long sql query
SQL
0 vote223 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
0 vote233 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote257 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
6 votes237 views2 answers
Database url postgres
SQL
11 votes243 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
0 vote244 views1 answer
Sql stored procedure update if parameter is not null
SQL
0 vote255 views2 answers
Faster mysql imports
SQL