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 vote289 views1 answer
Sqlite update only if greater
SQL
0 vote315 views1 answer
Check user sql password from command line
SQL
1 vote293 views2 answers
Sql left characters
SQL
0 vote304 views1 answer
Mysql error 1452
SQL
5 votes304 views2 answers
Create function postgresql
SQL
0 vote281 views2 answers
Show slave status mysql
SQL
4 votes285 views2 answers
Mysql show indexes on table
SQL
0 vote285 views1 answer
Sql last 7 days
SQL
0 vote307 views4 answers
User defined function sql
SQL
1 vote342 views1 answer
Mysql default port
SQL