I got an error when implementing tde in sql2008

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 4:33 UTC
Read the original article Hit count: 242

Filed under:

while using

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

getting 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