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

4 votes323 views2 answers
How to delete row in sql
SQL
5 votes341 views1 answer
Mysql get last day of month
SQL
0 vote348 views2 answers
How to tun mysql on ubunto
SQL
0 vote327 views1 answer
Sql max min
SQL
21 votes362 views4 answers
Add column mssql
SQL
0 vote341 views1 answer
Postgresql delete multiple rows
SQL
0 vote325 views1 answer
Not between mysql
SQL
0 vote333 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote420 views1 answer
Oracle calculate statistics on partition
SQL
0 vote409 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL