How to encrypt a column? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to encrypt a column?

According to my understanding, MS SQL Server does not have any built-in mechanism to encrypt a column. One way to encrypt column seems to use Microsoft CryptoAPI. Does anyone have any example how to do this? Thank you for any help. for more information. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Why does this need to be done at the server? More or less easy exercise for any front-end language.

All that you need to do is encrypt the data before you enter it into your database. If you’re using a .NET language, encryption is very easy.
Try this for server-side encryption: