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: 201
Filed under:
sql-server
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
