/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 vote132 views1 answer
Oracle service name view
SQL
0 vote136 views1 answer
Codeigniter dbforge add index
SQL
1 vote149 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
0 vote92 views1 answer
Check if due date is less than todays date sql
SQL
1 vote135 views1 answer
Table information in sql server
SQL
0 vote177 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote146 views1 answer
Query for backup a database at another location in file system
SQL
0 vote159 views8 answers
Sql to c# linq converter online
SQL
1 vote154 views1 answer
How to delay stored procedure execution in sql server
SQL
0 vote130 views1 answer
Sqlite explain plan
SQL