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: 373
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