/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 vote261 views1 answer
Dump db only triggers mysql
SQL
0 vote270 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
1 vote254 views1 answer
Is sql fast
SQL
4 votes236 views2 answers
Oracle set date format
SQL
1 vote281 views2 answers
Sql split string by space
SQL
3 votes265 views1 answer
Locate sql server
SQL
0 vote254 views1 answer
Get first monday of month sql
SQL
1 vote251 views1 answer
How to drop function in sql
SQL
6 votes243 views3 answers
Mysql first day of year
SQL
0 vote267 views1 answer
Foreign key type uniqu mysql
SQL