/SQL/Search text in all sql server stored procedure

Search text in all sql server stored procedure

SELECT OBJECT_NAME(object_id)
    FROM sys.sql_modules
    WHERE OBJECTPROPERTY(object_id, 'IsProcedure') = 1
    AND definition LIKE '%Foo%'

Source: stackoverflow.com

Search stored procedures

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]%';

Similar codes

0 vote285 views1 answer
Narural join
SQL
5 votes253 views1 answer
Postgres upsert
SQL
3 votes291 views2 answers
How to modify rows in SQL Server
SQL
15 votes527 views2 answers
How to sort names in alphabetical order in sql
SQL
2 votes328 views1 answer
Drop all foreign key constraints mysql
SQL
0 vote270 views1 answer
Access refused mysql xampp server
SQL
0 vote267 views1 answer
Myswql show full processlist
SQL
1 vote339 views1 answer
Sql select sum group by id laravel
SQL
6 votes239 views2 answers
Generate c# class from sql server table
SQL
1 vote340 views1 answer
How not to sort by average rating
SQL