/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 vote118 views1 answer
Call function sql oracle
SQL
0 vote146 views1 answer
Authentication modes in sql server
SQL
0 vote135 views1 answer
Database schema for mcqs type exam in sql
SQL
2 votes130 views1 answer
How to select first row of database sql
SQL
1 vote126 views2 answers
Mysql spring boot application.properties
SQL
0 vote120 views1 answer
Mysql show category once count how many products
SQL
14 votes135 views6 answers
Auto_increment mysql
SQL
-1 vote138 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
3 votes167 views2 answers
Brew restart mysql
SQL
0 vote160 views2 answers
How to login to mysql as normal user in ubuntu
SQL