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

4 votes307 views2 answers
Oracle unliock account
SQL
-1 vote313 views1 answer
Adding a new table psql
SQL
3 votes324 views1 answer
Pl sql escape &
SQL
1 vote354 views2 answers
One to one and one to many relationship
SQL
2 votes318 views1 answer
Sql server conection string
SQL
0 vote328 views1 answer
Insert output identity
SQL
0 vote315 views1 answer
Original Query
SQL
22 votes315 views3 answers
Sql cheat sheet
SQL
0 vote354 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote358 views1 answer
Select the date 30 days less that the todays date sql request
SQL