Re: Example code Help!

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 06:14:06 -0600

To add to the other responses, I strongly suggest you reconsider using this
undocumented functionality in production code. The algorithms may change
between SQL Server versions/service packs and break your application.

There are third-party tools available to do this or you can roll your own. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Chip" <chipsin007@yahoo.nospam.com> wrote in message
news:e99201c40c0c$ca210900$a301280a@phx.gbl...
> Dear folks,
>
> I am searching for example codes for encryption and
> decryption of a value for a column in SQL Server 2000.
> Last week Roji P Thomas suggested me the Undocumented
> functions PWDENCRYPT and PWDCOMAPRE but I dint find any
> example code in Google search on how to use them. I badly
> need some examples as I already have 30 thousand Password
> values in clear text and soon they increase in lakhs. Here
> is a scenario at present.
>
> The user will register for a web based service and his
> username and passcode details are stored in clear text :-(
>
> I need some guidance on how to encrypt for a given clear
> text input and store in DB table and decrypt the same when
> needed.
>
> Thanks for all the help
>
> sincerely
>
> Chip
>

Relevant Pages

  • Re: CREATE SYMMETRIC KEY
    ... AES is only supported by SQL Server on Windows 2003. ... To test it out using encryption, I created a database, TestEncrypt, ... CREATE SYMMETRIC KEY SSN_Key_01 ... DECRYPTION BY CERTIFICATE HumanResources037; ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2005 encryption with databound controls
    ... If you want the contents of the data encrypted inside the database, then you can encapsulate all the encryption and decryption inside stored procedures, and you can configure the DataAdapter to use those SPs, rather than the sql queries themselves. ... you would pass your data through the standard SQL Server 2005 functions for encryption and decryption before writing or reading the actual table. ... Die, die Binär verstehen, bzw. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: SQL-Server and Content encryption
    ... SQL Server does not have any encryption features built in like that. ... the encryption and decryption in the application. ... > read the data stored in the SQL-Server database? ...
    (microsoft.public.sqlserver.security)
  • Re: SQL-Server and Content encryption
    ... SQL Server 2000 didn't directly tackle the content encryption problem. ... "Andrew J. Kelly" wrote in message ... >>> the encryption and decryption in the application. ...
    (microsoft.public.sqlserver.security)
  • Re: Example code Help!
    ... Dan has planted a bomb in my heart, ... >between SQL Server versions/service packs and break your ... >> I am searching for example codes for encryption and ... >> decryption of a value for a column in SQL Server 2000. ...
    (microsoft.public.sqlserver.server)