| Author |
 Topic  |
|
|
rammohan
Posting Yak Master
India
212 Posts |
 Posted - 09/09/2010 : 11:47:32
|
Hi,
As per requirement, i need to encrypt the data which is going to stored in a column say A, and need to decrypted while retrieving it.
I have done same thing using symmetric keys in sqlserver2005, Is there any way to achieve the same in sqlserver2000
Thanks,
Rammohan
One can never consent to creep,when one feels an impulse to soar
RAMMOHAN
|
|
|
robvolk
Most Valuable Yak
USA
15559 Posts |
Posted - 09/09/2010 : 11:54:42
|
| You'll either have to encrypt and decrypt it in your application layer, or write a procedure or user-defined T-SQL function to do it. SQL Server 2000 doesn't have any strong encryption functions built-in, no decryption functions, and they're not documented or supported for production use. |
 |
|
|
rammohan
Posting Yak Master
India
212 Posts |
Posted - 09/09/2010 : 11:59:03
|
Hi,,
Thank you for giving reply. Please help me to write a sp for it. i am not getting idea to how to start it.
Please give me any suggestions
One can never consent to creep,when one feels an impulse to soar
RAMMOHAN
|
|
|
|
robvolk
Most Valuable Yak
USA
15559 Posts |
Posted - 09/09/2010 : 12:00:53
|
I don't know anything about encryption techniques or what encryption you want to use, I wouldn't be able to help you write such a procedure.
Google is your friend, you'll probably find a procedure out there, or a 3rd party utility you can use/purchase. |
|
|
| |
Topic |
|
Reg : Encrypton and decryption
