/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

1 vote358 views2 answers
Sql server concat string and int
SQL
0 vote353 views1 answer
Android sqlite add column if not exists
SQL
3 votes403 views2 answers
See mysql users ubuntu
SQL
10 votes324 views2 answers
Mysql select timestamp group by day
SQL
4 votes373 views5 answers
Get last query in codeigniter 4
SQL
0 vote348 views1 answer
Add column to table with default value plsql
SQL
2 votes323 views2 answers
Mysql all columns
SQL
1 vote348 views1 answer
Postgres convert date to string
SQL
0 vote363 views1 answer
How to add boolean column in postgresql
SQL
4 votes332 views1 answer
To date oracle with time
SQL