我执行SQL Server 2008中
问题描述:
USE MyDatabase
GO
CREATE DATABASE ENCRYPTION KEY
WITH ENCRYPTION
ALGORITHM = AES_256 BY SERVER CERTIFICATE TDECert
GO
TDE时得到一个错误,当我在SQL Server 2008中执行该语句,我得到的错误:我执行SQL Server 2008中
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'KEY'.
Msg 319, Level 15, State 1, Line 2
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.
怎么办? 我只是想加密我的分贝。
答
我你的榜样和MSDN例子间看到的唯一区别是字的大写WITH
答
你错过了什么是加密通过,因此修正后的脚本将低于:
USE MyDatabase
GO
CREATE DATABASE ENCRYPTION KEY
WITH ENCRYPTION ALGORITHM = AES_256
ENCRYPTION BY SERVER CERTIFICATE TDECert
GO
请努力在你的问题中使用真实的文字 – 2010-06-18 04:19:33
并阅读文档将有所帮助。你想让我们做什么?复制粘贴? – TomTom 2010-06-18 04:21:00
下一次,请格式化您的问题。 – 2010-06-18 14:56:06