/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 vote193 views1 answer
Sql field equals multiple values
SQL
0 vote152 views1 answer
Duplicate foreign key constraint name
SQL
1 vote165 views10 answers
Stack overflow
SQL
0 vote175 views1 answer
Sql values that contains certain multiple ids
SQL
0 vote191 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
1 vote164 views2 answers
Sql for date greater than
SQL
5 votes246 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
15 votes178 views4 answers
Pl sql
SQL
3 votes171 views1 answer
Get all elements sql
SQL
39 votes280 views5 answers
Sql drop column
SQL