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

23 votes303 views6 answers
How to create table in sql
SQL
0 vote277 views2 answers
T SQl Checking Your Username
SQL
1 vote301 views1 answer
Oracle sql first day of year
SQL
0 vote282 views1 answer
Load utilities in sql server
SQL
0 vote295 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote230 views1 answer
Check id exist or not in sql
SQL
1 vote297 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote297 views1 answer
Isnull in sqlite
SQL
25 votes300 views5 answers
Date in mysql
SQL
0 vote352 views1 answer
Oracle convert int to date
SQL