Encrypting Column data and using triggers

[pbsadmin]

Hello All,

I'm working on encrypting 2 columns from a table that are storing sensitive information, as I am not too familiar with SQL queries, I was wondering if there was a method to:


1. encrypt the existing data in the columns (there are approx 400 rows)

2. make the encryption transparent to SQL code that calls it (i.e. encrypt and decrypt the column data "on the fly")
with a view or trigger, etc

we are running SQL server 2005

any help would be appreciated,

thanks,

 

[simian336]

I think I read last night that you have to have SS Enterprise or Developer editions to do encryption. Can anybody verify that?

Thanks

Simi

 

[philhege]

True. There's a push among a group of MVPs/DBAs to include encryption in the Standard edition. Stay tuned.

-------++NO CARRIER++-------