/SQL/Find string in stored procedure sql server

Find string in stored procedure sql server

SELECT name
FROM   sys.procedures
WHERE  Object_definition(object_id) LIKE '%strHell%'

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 vote137 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
11 votes101 views5 answers
How to install sqlite3 python
SQL
5 votes107 views3 answers
Mysql remove unique constraint
SQL
0 vote108 views1 answer
Sql shell psql cannot enter password
SQL
0 vote99 views1 answer
Sql compound operators
SQL
1 vote119 views1 answer
UseSqlServer no definition
SQL
0 vote112 views1 answer
Mysql remove last character
SQL
12 votes100 views2 answers
Select into insert sql server
SQL
0 vote104 views1 answer
Oracle allow space to user
SQL
-1 vote114 views1 answer
Ms sql select datetime as date
SQL