/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 vote142 views1 answer
Ajax error exception handeling
SQL
-2 votes192 views3 answers
How to fetch first 10 rows in sql
SQL
1 vote135 views1 answer
Update and replace mysql
SQL
0 vote127 views1 answer
Mysql group rows with same value
SQL
1 vote139 views1 answer
Load sql into mamp
SQL
0 vote128 views1 answer
Get first name and last name from full name string in SQL
SQL
0 vote134 views1 answer
Addition of 2 column value in mysql
SQL
5 votes148 views6 answers
In operator sql
SQL
0 vote147 views1 answer
Get from database the most recent data limit by 5
SQL
3 votes175 views2 answers
@sqlresultsetmapping
SQL