Microsoft SQL Server
SQL Server Tutorial, Query's and Interview Questions
Friday, 3 April 2015
List all the stored procedures User created by SQL query.?
select
*
from
information_schema
.
routines
where
routine_type
=
'PROCEDURE'
and
Left(
Routine_Name
,
3
)
NOT
IN
(
'sp_'
,
'xp_'
,
'ms_'
,
'dt_'
)
or
select
*
from
sys
.
procedures
where
is_ms_shipped
=
0
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment