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

1 vote240 views3 answers
Mysql connection string
SQL
5 votes254 views3 answers
Postgres show databases
SQL
2 votes255 views1 answer
Sql server find columns list in tables
SQL
1 vote261 views1 answer
Select users with same username
SQL
0 vote232 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
1 vote241 views1 answer
Simple project for database
SQL
0 vote245 views1 answer
Create a sql server database programmatically
SQL
0 vote297 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
0 vote253 views1 answer
The package java.sql is not accessible
SQL
0 vote246 views1 answer
Php select data from mysql database without column name
SQL