Re: To Decrypt the encrypted storedprocedure MS SQL2000

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 06/30/04 

Date: Wed, 30 Jun 2004 15:40:53 +0100

Have a search in Google, and you will find code to decrypt encrypted stored
procs. Regarding your last question, see SQLSecurity.com 

-- 
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Vikas Gupta" <vikas@ace-infotech.com> wrote in message
news:23b0301c45eaa$51582940$a501280a@phx.gbl...
Hi,
We are using MSSQL 2000 as database server. In that we are
using encrypted storedprocedure using default encryption
property provided by MSsql2000.
Now We want to decrypt the procedure to edit its logic.
But unable to decrypt.
Now we want to know few things.
1) How we can decrypt the storedprocedure?
2) Where is the key stored and what type of key used to
encrypt.
3) We want to achive max security to our sensitive data if
somebody hack the master login/password for sql then also
he should not allow to view the data.
Thanks.
Regards,
Vikas Gupta

Relevant Pages

  • Re: SQL Server 2000 / 2005 Encryption
    ... to encrypt your SSL connections will be different. ... SQL Server can generate its own self-signed certificates though, and that should make the SSL encryption/connectivity easier for you. ... Excel does not know how to decrypt data stored in SQL Server 2005 in encrypted form. ...
    (microsoft.public.sqlserver.security)
  • Re: Encrypting & Decrypting
    ... > now i have learnt how to decrypt form google. ... >>Object encryption in sql server is really more object ... >>>>Mark Broadbent mcse+i, mcdba ...
    (microsoft.public.sqlserver.security)
  • Re: managing application role passwords without hard-coding them into applications
    ... app, authenticating as the person, to select the password. ... internally decrypt the password then switch to the application role. ... > SQL Server database), for which only the application has ... > being hard coded into the app (ie preventing developers ...
    (microsoft.public.sqlserver.security)
  • Re: Decryption of SQL Server Login pwd
    ... You are not supposed to be able to decrypt it. ... Hal Berenson, SQL Server MVP ... True Mountain Group LLC ... "Hartono" wrote in message ...
    (microsoft.public.sqlserver.security)
  • Re: Decrypt Stored Proc ...
    ... SQL Server doesn't provide any built-in mechanism to decrypt encrypted ... stored procedures. ... tools/code to decrypt the encrypted procedures. ...
    (microsoft.public.sqlserver.programming)