Search stored procedures

Search stored procedures by name

select * 
from 
   sys.procedures 
where 
   name like '%name_of_proc%'

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 vote135 views1 answer
Drop CHECK constraint sql
SQL
0 vote121 views1 answer
Remove binlog mysql
SQL
0 vote138 views1 answer
Plsql check for string in numeric
SQL
0 vote158 views1 answer
ORACLE PARSE STRING
SQL
8 votes116 views1 answer
Sql remove characters from string right
SQL
0 vote151 views1 answer
Sql server remove primary key without dropping table
SQL
9 votes140 views5 answers
Laravel to sql
SQL
-1 vote164 views3 answers
SQL MM/dd/yyyy format
SQL
0 vote119 views1 answer
Sqlalchemy sequence postgresql
SQL
3 votes130 views3 answers
Remove all spaces from string sql
SQL