Hi Sean AND Steve..

The following is totally not just to prove myself..but just got an idea in my mind, and want to discuss with you guys, before I waste my time on that.

Can I use single cloumn encryption from the following article

http://msdn.microsoft.com/en-us/library/ms179331.aspx

and then delete the clear text column from every table..

And then retrict the user to decrypt that data(I DON'T KNOW WHETHER THIS KIND OF FUNCTIONALITY IS THERE IN SQL SERVER OR NOT, THAT WE CAN RESTRICT USER TO PERFORM DECRYPT OPERATION)

and only admin can decrypt the column when he needs to refere encrypted data to clear text.

Is this possible?

thanks.