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 vote182 views2 answers
Add colum in sql
SQL
12 votes202 views6 answers
Change mysql root password
SQL
2 votes177 views1 answer
Sql update from different table
SQL
0 vote180 views1 answer
Oracle show running job
SQL
0 vote179 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
4 votes173 views1 answer
Restart for pg_hba.conf file
SQL
17 votes206 views2 answers
T_sql contains
SQL
0 vote130 views1 answer
Sqlalchemy existing database
SQL
0 vote183 views1 answer
000webhost database values insert
SQL
14 votes214 views6 answers
Finding duplicate rows mysql
SQL