/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

8 votes223 views2 answers
Mysql grant all privileges to user from any host
SQL
2 votes207 views1 answer
How to add where command in update comand with joins
SQL
0 vote221 views1 answer
SQL SERVER xquery count child nodes
SQL
0 vote205 views1 answer
Mysql count number of occurrences in a column
SQL
0 vote196 views1 answer
Get records in sql according to month name and count
SQL
0 vote207 views1 answer
Connect by query in oracle
SQL
0 vote209 views1 answer
Sql get year from datetime field
SQL
0 vote213 views1 answer
Oracle change password expiration policy
SQL
1 vote154 views1 answer
How to run sql script
SQL
4 votes191 views1 answer
SQL order random
SQL