Thursday, January 07, 2010 7:53 PMWhat 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.
Thursday, January 07, 2010 8:06 PM
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:
Apply the encryption key to the column.
You dont need to have enterprise edition for this option.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
The article above tells you step by step on implementing a column level encryption.
- Marked As Answer by MikeVB Thursday, January 07, 2010 8:51 PM
Thursday, January 07, 2010 8:51 PMThank you very much. This is just what I need to know.