/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
SQL SELECT-Klausel
SQL
2 votes213 views1 answer
Tsql copy table
SQL
0 vote140 views1 answer
Mysql begin statement
SQL
1 vote144 views1 answer
SQL query to get all table records count from a database
SQL
2 votes141 views4 answers
Check timezone of mysql database
SQL
0 vote164 views2 answers
How to see table associated with a schema in sql
SQL
1 vote148 views1 answer
Mysql decimal allow negative values?
SQL
0 vote159 views1 answer
Mql5 datetime get hour
SQL
2 votes145 views1 answer
Sqlite indexes
SQL
0 vote141 views1 answer
Search from comma separated values in sql server
SQL