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

1 vote389 views1 answer
Postgres convert text to number
SQL
18 votes197 views3 answers
Find column name in database
SQL
4 votes305 views4 answers
Remove duplicate old value in mysql
SQL
0 vote275 views1 answer
Offset in postgresql example
SQL
13 votes193 views4 answers
Mysql select last 10 rows
SQL
0 vote192 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
5 votes206 views2 answers
Mysql import gzip db
SQL
9 votes232 views3 answers
Date format in sql
SQL
0 vote199 views1 answer
Mod function example
SQL
0 vote211 views1 answer
Mysql 5.6 hierarchical recursive query
SQL