I got an error when implementing tde in sql2008
- by mahima
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