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 vote153 views1 answer
Limit in access query
SQL
0 vote197 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
0 vote166 views1 answer
Finding leap year in sql
SQL
4 votes135 views3 answers
Oracle sql first day of quarter
SQL
0 vote138 views1 answer
Oracle last character of string
SQL
0 vote201 views1 answer
Sql server system messeges
SQL
0 vote138 views1 answer
Can we rollback deleted data in sql
SQL
0 vote145 views1 answer
Mysql grant grant option
SQL
14 votes162 views1 answer
Excel is not a database
SQL
0 vote139 views1 answer
Mysql find non alphanumeric characters
SQL