SQL Server 2008 Standard Edition Encryption

Question

What are my column-level encryption options for SQL Server 2008 Standard Edition?  I can see that http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/b0fb44e2-3496-4022-873f-db2521ac2cc5/ indicates that Transparent Data Encryption (TDE) is only available with the SQL Server 2008 Enterprise Edition.

Thanks,

Mike 

Answer 1

TDE is entirely different from column-level encryption that you are looking at.
From SQL Server 2005, native encryption capabilities are available.
In this article (How To: Encrypt a Column of Data) an example is provided to build the following:
Master key
Certificate
Symmetric key
Apply the encryption key to the column.

You dont need to have enterprise edition for this option.
The article above tells you step by step on implementing a column level encryption.

And this article from MS guys Laurentiu should also help you - http://blogs.msdn.com/lcris/archive/2005/06/10/sql-server-2005-column-encryption-demo-part-2.aspx

---

Thanks, Leks

Answer 2

Thank you very much.  This is just what I need to know.