/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

9 votes397 views4 answers
Mysql set id auto increment
SQL
0 vote455 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
1 vote366 views1 answer
Mysql data from file
SQL
1 vote381 views1 answer
OstgreSQL version
SQL
1 vote364 views1 answer
SQL: merging multiple row data in string
SQL
0 vote339 views1 answer
Grant access on table in oracle
SQL
23 votes367 views1 answer
How remove column in mysql
SQL
0 vote359 views1 answer
Make a socket server to detect changes in mysql
SQL
0 vote388 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote344 views2 answers
Install phoenix
SQL