snippetsqlMinor
How to query the names of encrypted stored procedures?
Viewed 0 times
storedproceduresthequeryencryptednameshow
Problem
What query will identify the names of stored procedures which are encrypted? Here's what I got so far -
Thanks in advance.
select ROUTINE_NAME
from INFORMATION_SCHEMA.ROUTINES
where ROUTINE_TYPE = 'PROCEDURE'
-- need another condition here to identify just the encrypted SPROC's
order by ROUTINE_NAME ascThanks in advance.
Solution
select ROUTINE_NAME
from INFORMATION_SCHEMA.ROUTINES
where ROUTINE_TYPE = 'PROCEDURE'
and ROUTINE_DEFINITION is null
order by ROUTINE_NAME ascAn encrypted Stored Procedure will have a
NULL ROUTINE_DEFINITION.Code Snippets
select ROUTINE_NAME
from INFORMATION_SCHEMA.ROUTINES
where ROUTINE_TYPE = 'PROCEDURE'
and ROUTINE_DEFINITION is null
order by ROUTINE_NAME ascContext
StackExchange Database Administrators Q#15100, answer score: 3
Revisions (0)
No revisions yet.