/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 vote142 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
2 votes138 views1 answer
Find all triggers in database
SQL
0 vote185 views1 answer
Generate sql from specific migration ef core
SQL
4 votes170 views1 answer
Postgresql change default value
SQL
1 vote141 views1 answer
Postgres concat_ws
SQL
0 vote199 views1 answer
Postgres rename database
SQL
22 votes210 views4 answers
Mysql date format
SQL
0 vote165 views1 answer
Sql alter column name sql server
SQL
0 vote138 views2 answers
Sql server Insert Into table
SQL
2 votes173 views1 answer
Show max_allowed_packet mysql
SQL