Database Experts help please

Hi

Does anyone know if its possible to encrypt data within an SQL 2005 database. I urgently need to remediate an issue for some data that needs to be protected within the database. Does anyone know if this is possible. I did a quick google but I'm getting some conflicting answers. I would really appreciate any help.

Thanks

Find more posts tagged with

Comments

NotHackingYou

I think what you are looking for is called column level encryption. I have set this up before, it's not super hard but you will need to work with it a bit to get the hang of it. Your application also must be able to handle the encrypted value. Here's the MSDN on it: How to: Encrypt a Column of Data

NightShade03

@CarlSaiyed is correct. You can do column level encryption or full table encryption. Here is a similar article:

Encrypt a Column of Data

You can also leverage a third party tool like Voltage to assist or use the programming language to encrypt the data before it is inserted into the database.