Re: Example code Help!
From: Chip (anonymous_at_discussions.microsoft.com)
Date: 03/17/04
- Next message: Journika: "dbo can't bring DB online"
- Previous message: Tibor Karaszi: "Re: DB capability, daily backup, import access and excel files"
- In reply to: Dan Guzman: "Re: Example code Help!"
- Next in thread: Tom Moreau: "Re: Example code Help!"
- Reply: Tom Moreau: "Re: Example code Help!"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 17 Mar 2004 06:08:34 -0800
Hi Ray & Hari & Dan!
Thanks for the inputs. Dan has planted a bomb in my heart,
which makes sense. where should i go now? Do u guys
encountered any thirdpaty tools at low cost or somebody
developed such tool for free to favour SQL Community.
Sincerely
Chip
>-----Original Message-----
>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
>>
>
>
>.
>
- Next message: Journika: "dbo can't bring DB online"
- Previous message: Tibor Karaszi: "Re: DB capability, daily backup, import access and excel files"
- In reply to: Dan Guzman: "Re: Example code Help!"
- Next in thread: Tom Moreau: "Re: Example code Help!"
- Reply: Tom Moreau: "Re: Example code Help!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
