/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 vote175 views1 answer
Search In the Data using ObjectName
SQL
0 vote163 views1 answer
Microsoft word insert sql code
SQL
2 votes172 views2 answers
How to view created temporary tables in mysql
SQL
1 vote166 views3 answers
Epoch to datetime
SQL
1 vote196 views1 answer
Show databases mysql docker
SQL
0 vote175 views1 answer
Oracle SQL join three tables and group by column
SQL
0 vote172 views1 answer
To change the database owner in SQL server
SQL
0 vote177 views1 answer
Python mysql executemany
SQL
11 votes174 views4 answers
MYSQL LOGIN
SQL
1 vote183 views1 answer
Mysql show database size in mb
SQL