I get an error when implementing tde in SQL Server 2008
- by mahima
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