/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 vote139 views1 answer
Postgres set default schema
SQL
0 vote185 views1 answer
Sql multiple into
SQL
3 votes171 views3 answers
Start postgresql ubuntu
SQL
3 votes194 views2 answers
How to View column names of a table in SQL
SQL
13 votes166 views1 answer
Sql join 3 tables on id
SQL
2 votes197 views1 answer
Oracle Column Names of a table
SQL
0 vote143 views1 answer
Run mssql server terminal
SQL
0 vote132 views1 answer
Materialized view redshift
SQL
0 vote145 views1 answer
Exec procedure oracle
SQL
0 vote138 views1 answer
Import big data to mysql
SQL