Is there any feature like TDE for column level encryption on SQL Server 2008 that works transparently?

Question

I want to know that, is there any feature in SQL Server 2008 for column level data encryption like TDE?

score 0 · Answer 1 · answered Mar 10 '12 at 18:49

0

You could try writing a view with triggers for insert, update, and delete on top of your data that uses one of the cell-level encryption functions. The user of the view would need to have the key open, but it should work aside from that.

answered Mar 10 '12 at 18:49

Ben Thul

31,080
4
45
68

Is there any feature like TDE for column level encryption on SQL Server 2008 that works transparently?

1 Answers1