开发者

Create Local Database Cache - Use SQL Server change tracking is disabled

开发者 https://www.devze.com 2023-01-07 22:23 出处:网络
I\'m trying to create a new \"Local Database Cache\" item in Visual Studio 2010 to sync against a local Sql Server Express 2008 R2 database.

I'm trying to create a new "Local Database Cache" item in Visual Studio 2010 to sync against a local Sql Server Express 2008 R2 database.

When the wizard pops up though开发者_StackOverflow中文版 the "Use SQL Server change tracking" checkbox is disabled. Any ideas? I tried running

ALTER DATABASE MY_Database SET CHANGE_TRACKING = ON

but that had no effect.

Cheers,

Alex..


Figured this out..

The database was set to SQL Server 2000 compatibility, set it to SQL Server 2008 and all is good...

0

精彩评论

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