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

2 votes135 views2 answers
Created at and updated at in mysql
SQL
0 vote142 views1 answer
Mysql zerofill
SQL
1 vote147 views2 answers
Sql drop multiple columns if exists
SQL
0 vote152 views1 answer
Xamarin sql lite create table if not exist
SQL
2 votes136 views1 answer
Set username and password for postgresql database
SQL
0 vote148 views1 answer
Reset keys in sql
SQL
14 votes138 views3 answers
Alter foreign key
SQL
0 vote129 views1 answer
Call function in query sql server
SQL
10 votes150 views6 answers
Sql between
SQL
0 vote159 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL