SQL Field encryption

[CasperTFG]

Is it possible to encrypt a column in a DB? I can easily encrypt the column before putting it in the DB and then Decrypting when I take it out. But this means I can't use Crystal to display this column anymore.

Casper

There is room for all of gods creatures, "Right Beside the Mashed Potatoes".

 

[jbenson001]

You could still use Crystal, but you would have to use a stored procedure that does the decryption.

Jim

 

[mrdenny]

If you are using SQL 7/SQL 2000 then you would need a 3rd party dll to do the encrypting. The dll would need to be setup as an extended stored procedure which could then be called via T/SQL.

If you are using SQL 2005 it supports encryption nativly.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com