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