/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 vote194 views1 answer
Mysql match in serialized data
SQL
-1 vote207 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
1 vote267 views1 answer
Sql oracle update multiple rows
SQL
18 votes273 views3 answers
Get the list of all tables in sql server
SQL
0 vote185 views3 answers
Postgresql grant alter table to user
SQL
3 votes216 views2 answers
Sqlite show table structure
SQL
0 vote196 views1 answer
What is metadata in sql
SQL
18 votes196 views6 answers
Create table mysql
SQL
1 vote219 views1 answer
Minus vs intersect in sql
SQL
1 vote256 views1 answer
How to put value in variable mysql
SQL