Data Encryption

[Christina Ko]

Hi,

I am looking for a way to encrypt a column in my SQL Server Table. I have been looking in the books and have not found anything. Any ideas of how to do it?

[Kenneth Wilhelmsson]

Easy. Use the (undocumented) encrypt() function.

However, if you want to decrypt it again, you have to code that yourself, since
there are no decrypt() function.

Look in sp_password for example of use of encrypt()

/Kenneth
------------
Christina Ko at 4/8/99 7:58:44 AM

Hi,

I am looking for a way to encrypt a column in my SQL Server Table. I have been looking in the books and have not found anything. Any ideas of how to do it?

[Christina Ko]

Hi Kenneth,

Thanks for your response. Since the encrypt( ) is not documented, do you have any example. I would like to encrypt the SSN column in my table and decrypt it when needed.

------------
Christina Ko at 4/8/99 7:58:44 AM

Hi,

I am looking for a way to encrypt a column in my SQL Server Table. I have been looking in the books and have not found anything. Any ideas of how to do it?

[Gregory]

maybe perform encryption/decryption in front-end? instead of doing it at back-end?

for example, you can use
1) 'xor' function to encrypt/decrypt text
or
2) use crypto API functions

.....?

mail me if need more info


------------
Christina Ko at 4/9/99 7:43:50 AM


Hi Kenneth,

Thanks for your response. Since the encrypt( ) is not documented, do you have any example. I would like to encrypt the SSN column in my table and decrypt it when needed.

------------
Christina Ko at 4/8/99 7:58:44 AM

Hi,

I am looking for a way to encrypt a column in my SQL Server Table. I have been looking in the books and have not found anything. Any ideas of how to do it?

[Dmitry Nickoulenko]

Whether one Can be removed the encoded procedure code from the table syscomments?
And how this will tell posteriorly on the fortune SQL Server?

Thanks. Dmitry.