i tried to implement tde in sql2008...n got the error below.....plz help me to resolve...

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:23 UTC
Read the original article Hit count: 222

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