/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

3 votes254 views3 answers
Mysql get table size
SQL
0 vote253 views1 answer
Concatenate columns in table
SQL
0 vote277 views1 answer
Close sql query vb.net
SQL
0 vote278 views1 answer
How to get specific salary in sql
SQL
0 vote288 views1 answer
Dataframe lambda elif
SQL
4 votes252 views1 answer
To date oracle with time
SQL
0 vote275 views2 answers
Mysql dump structure only
SQL
0 vote265 views1 answer
Sql server size of every table in a db
SQL
0 vote283 views3 answers
Sql parenthetical expression examples
SQL
21 votes281 views3 answers
Sql server search column name in all tables
SQL