I get an error when implementing tde in SQL Server 2008

Posted by mahima on Stack Overflow See other posts from Stack Overflow or by mahima
Published on 2010-06-18T04:13:39Z Indexed on 2010/06/18 5:13 UTC
Read the original article Hit count: 345

While using

USE mssqltips_tde; 
CREATE DATABASE ENCRYPTION KEY with ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE TDECert 
GO

I'm getting an error

Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'KEY'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.

please help in resolving the same as i need to implement Encryption on my DB

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sql-server-2008