One more question... Can I follow the method mentioned in this article on my local system which holds SQL Server 2005 and test it and then install the same on...

I have another question.. Is it possible to use the ENCRYPTION BY PASSWORD temporarily and later rerplace it with the certificate?

Marios, Thanks for the information. I would definitely consider using the Certificates.

Thanks a lot! Yes, I need to install the DB on SQL Server 2008 at the client's place. But I have only 2005 on my system to work on.. I...

Hi Mike,

Thanks for an excellent article.. I am a developer and not a DBA. However, I cannot implement encryption without knowing the details in-depth about the same. Your article helped...