开发者

READ_COMMITTED_SNAPSHOT not recognized by SQL Server 2005

开发者 https://www.devze.com 2023-02-13 13:37 出处:网络
We\'re running SQL Serve开发者_运维技巧r 2005 Enterprise SP3, and I\'m trying to enable Row Versioning on a new database running in sql server 2005 mode.

We're running SQL Serve开发者_运维技巧r 2005 Enterprise SP3, and I'm trying to enable Row Versioning on a new database running in sql server 2005 mode.

Query (against master database):

ALTER DATABASE pod-moodle SET READ_COMMITTED_SNAPSHOT ON

Result:

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '-'.
Msg 195, Level 15, State 5, Line 1
'READ_COMMITTED_SNAPSHOT' is not a recognized SET option.

Any ideas? I've triple-checked the master database and the pod-moodle database, they are both running in 2005 mode.


If you use non-aplhanumeric characters in identifiers, then you need to delimit with [ and ]

ALTER DATABASE [pod-moodle] SET READ_COMMITTED_SNAPSHOT ON
0

精彩评论

暂无评论...
验证码 换一张
取 消