/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 vote158 views1 answer
Sql server user permissions and roles
SQL
1 vote156 views1 answer
Mysql find most common value
SQL
0 vote166 views1 answer
Postgre query date
SQL
6 votes146 views2 answers
If not exists insert sql
SQL
31 votes166 views3 answers
Sql count
SQL
0 vote165 views1 answer
Compare if is null sql
SQL
1 vote188 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
0 vote144 views1 answer
Update top 100 sql
SQL
12 votes155 views2 answers
Delete all entries postgres
SQL
0 vote144 views1 answer
Sql delete where x or y or z
SQL