/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

1 vote121 views1 answer
Check current sequence value postgres
SQL
4 votes120 views3 answers
Is not null sql
SQL
0 vote126 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
0 vote104 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
0 vote100 views1 answer
Sql developer search all packages for text
SQL
1 vote122 views1 answer
UseSqlServer no definition
SQL
23 votes92 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote100 views1 answer
Vbscript connect mssql
SQL
0 vote115 views1 answer
Codigo crear tablas sql server
SQL
0 vote101 views1 answer
Declare date variable sql
SQL