/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

6 votes288 views2 answers
Non relational database
SQL
0 vote261 views1 answer
Sql server delete records with specific date
SQL
0 vote265 views1 answer
Implizite joins sql
SQL
0 vote294 views1 answer
How to map sql column to custom names
SQL
1 vote273 views1 answer
DATE_SUB postgres
SQL
6 votes300 views1 answer
Oracle trigger after logon on database
SQL
36 votes340 views6 answers
Change column data type sql
SQL
0 vote256 views1 answer
Oracle select invalid views
SQL
1 vote262 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
0 vote277 views1 answer
Search In the Database using Text
SQL