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 vote100 views1 answer
Group_concat only returns one row
SQL
3 votes120 views2 answers
Mysql import gz
SQL
1 vote91 views1 answer
Index a database column sql
SQL
8 votes124 views2 answers
How to fetch data from database without last column
SQL
0 vote92 views1 answer
Change default schema sql server
SQL
0 vote132 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote102 views1 answer
Make a socket server to detect changes in mysql
SQL
7 votes104 views3 answers
Restore postgres database from sql file
SQL
0 vote94 views1 answer
Import mysql'
SQL
0 vote104 views1 answer
Sqlite3 get data from table c
SQL