/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 vote331 views1 answer
Criteria builder select subset of column
SQL
0 vote371 views1 answer
Netstat -tln mysql
SQL
0 vote364 views1 answer
Sql select column name like from multiple tables
SQL
1 vote309 views1 answer
Mysql select row with max value group by
SQL
0 vote332 views1 answer
Postgresql where clause not working
SQL
3 votes318 views1 answer
How to remove characters from string in mysql
SQL
1 vote335 views1 answer
Count mysql server db tables
SQL
4 votes342 views2 answers
Oracle unlock user
SQL
3 votes334 views1 answer
How to uninstall microsoft sql server
SQL
1 vote375 views1 answer
Db.Database.SqlQuery
SQL