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

4 votes210 views4 answers
Check constraint in ms sql
SQL
0 vote199 views1 answer
Mysql create table columns with spaces
SQL
7 votes219 views1 answer
Query postgres delete duplicates
SQL
0 vote850 views2 answers
Remove mysql workbench ubuntu
SQL
0 vote213 views1 answer
Insert into select with group by
SQL
3 votes211 views1 answer
Oracle undo tablespace list by user
SQL
0 vote193 views1 answer
Mysql select all table that have field names
SQL
3 votes192 views1 answer
Oracle list user grants
SQL
1 vote202 views1 answer
Oracle sql create or replace view
SQL
0 vote199 views2 answers
Sql having multiple conditions
SQL