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 vote233 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
2 votes219 views1 answer
Python sql
SQL
0 vote185 views1 answer
How should I pass a table name into a stored proc?
SQL
0 vote319 views2 answers
Mysql insert rows to another database
SQL
1 vote186 views3 answers
Union in sql
SQL
0 vote224 views2 answers
Select index table oracle
SQL
0 vote837 views2 answers
Remove mysql workbench ubuntu
SQL
0 vote277 views1 answer
AddEntityFrameworkSqlite
SQL
1 vote222 views1 answer
Raw query must include primary key
SQL
1 vote187 views1 answer
Postgresql reset serial counter after deleting content
SQL