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

3 votes262 views2 answers
Sqlite print all column names
SQL
0 vote261 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote245 views1 answer
Sqldf change user
SQL
0 vote258 views1 answer
Many rows to 1 string mysql
SQL
1 vote257 views1 answer
Add constraint sql
SQL
5 votes272 views1 answer
Mysql last day of next month
SQL
0 vote264 views1 answer
Postgresql import a database of gzip
SQL
0 vote296 views1 answer
Sql constarint
SQL
15 votes280 views2 answers
Select where duplicate mysql
SQL
0 vote269 views1 answer
Group by max date
SQL