/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 vote303 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote300 views1 answer
Insert ip address in mysql
SQL
0 vote278 views1 answer
Mysql get last 2 month data
SQL
0 vote311 views1 answer
Mariadb create index if not exists
SQL
1 vote273 views1 answer
Type int in mysql maxlenght
SQL
2 votes327 views1 answer
Pdo mysql insert
SQL
1 vote270 views2 answers
Sql where is not number
SQL
0 vote281 views1 answer
Multiple tricky query in sql server
SQL
9 votes300 views1 answer
No sql
SQL
0 vote299 views1 answer
Call scalar valued function sql
SQL