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 vote133 views1 answer
Monthly Birthday SQL Query
SQL
0 vote145 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote163 views1 answer
How to combine rows in sql server procedure
SQL
0 vote137 views1 answer
Sql get number of days between two dates
SQL
1 vote132 views1 answer
How to select random rows from table
SQL
0 vote141 views4 answers
How to connect form to database
SQL
0 vote150 views1 answer
Postgres grep entire database
SQL
0 vote131 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
0 vote133 views1 answer
Create table if not exist with exceptions
SQL
0 vote200 views1 answer
Check user sql password from command line
SQL