Re: how to decrypt a encrypted stored proc in 2005
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Wed, 23 Aug 2006 14:47:45 -0600
That won't show it either. You can't see the definition of
encrypted stored procedures - that would kind of defeat the
purpose of encrypting them in the first place.
You need to have the original source code of stored
procedures created with the encryption option.
-Sue
On Wed, 23 Aug 2006 11:41:02 -0700, DallasBlue
<DallasBlue@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi,
can I get back the source code of the stored procedure which is created
with 'with encryption' option.
sys.sql_modules/sys.all_sql_modules/syscomments dosent show it even after
logging in DAC. All I see is null in the text column. and no luck with the
trace as well.
has anyone tried attaching a debugger to the server process to get the
encrypted stored procedures text ??
Thanks,
GA
.
- Prev by Date: Re: Encrypted database deployment
- Next by Date: Re: SQL 2000 Windows Authentication - Same User Multiple Groups
- Previous by thread: Re: SQL Server 2005 and default for Enforce password policy option
- Next by thread: Re: how to decrypt an encrypted stored proc in 2005
- Index(es):
Relevant Pages
|
