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 vote278 views1 answer
Sql server union if table exist
SQL
0 vote279 views1 answer
Merge clause with inner join
SQL
0 vote276 views1 answer
Sql add calculated column
SQL
0 vote266 views1 answer
Sql query to check if column contains alphabets
SQL
12 votes281 views2 answers
Delete all entries postgres
SQL
0 vote250 views1 answer
Linux upload database to mysql
SQL
3 votes284 views2 answers
MySQL query to get column names
SQL
0 vote291 views1 answer
Sql server list table sizes
SQL
0 vote297 views2 answers
Sql auto update dupdated_at
SQL
0 vote291 views1 answer
Mysql add text to existing field
SQL