/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 vote239 views1 answer
Delete record by id sql
SQL
0 vote262 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote273 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
7 votes257 views1 answer
Buy forge mods server hosting
SQL
0 vote227 views1 answer
Kotlin sqlite delete row
SQL
8 votes242 views1 answer
Unique vs primary key
SQL
4 votes301 views2 answers
Sql display today's date
SQL
0 vote226 views1 answer
What is between operator
SQL
0 vote233 views1 answer
Big table in mysql
SQL
8 votes256 views4 answers
Postgresql server restart
SQL