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 vote360 views2 answers
Select last 30 days sql
SQL
2 votes314 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
0 vote321 views3 answers
Find below average salary in sql
SQL
0 vote326 views1 answer
How to set all the min and sec data to zero in sql server
SQL
0 vote318 views1 answer
Oracle character index
SQL
0 vote358 views1 answer
Sql log file inof
SQL
1 vote347 views1 answer
Sql order by where condition
SQL
6 votes386 views3 answers
Check if string contains substring sql
SQL
1 vote327 views4 answers
Postgres extract date from timestamp
SQL
0 vote344 views1 answer
How to check which table has data in mysql
SQL