Encrypt and Decrypt the columns in table – SQL Server 2005

In a company have been asked to encrypt the few critical table columns contains containing sensitive data like Credit Card No, SSN even monthly generated payslip amount. Using SQL Server 2005 or 2008 we can encrypt data using different algorithms by creating symmetric and asymmetric keys. Continue reading