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

3 votes248 views1 answer
Oracle user quota unlimited
SQL
1 vote270 views1 answer
Postgresql float 2 decimal places
SQL
1 vote236 views1 answer
Update from select join
SQL
0 vote259 views1 answer
Mysql export search results
SQL
0 vote278 views1 answer
Oracle NLS_CHARACTERSET
SQL
1 vote279 views2 answers
Sql server backup table
SQL
1 vote269 views3 answers
How to filter repeated same result using sql query
SQL
0 vote243 views1 answer
Mysql xampp reset root password
SQL
4 votes329 views2 answers
Delete all table oracle
SQL
4 votes245 views2 answers
Insert current date in mysql
SQL