Hi, I am developing an application that uses Microsoft Sync Framework 2.1 to synchronize a client database with a server database. In my development environment I simply enable the "Change Tracking" feature (done in SQL Management Studio via right mouse clicking on the database, selecting Properties, selecting the Change Tracking page and finally setting Change Tracking to True). On my machine this works correctly, on the Winhost database I receive the following error. TITLE: Microsoft SQL Server Management Studio ------------------------------ Alter failed for Database 'DB_35040_samples'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?Prod...ceptionText&EvtID=Alter+Database&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The user does not have permission to perform this action. (Microsoft SQL Server, Error: 297) For help, click: http://go.microsoft.com/fwlink?Prod...100&EvtSrc=MSSQLServer&EvtID=297&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Any help would be appreciated! John
Hi John, I was able to enable Change Tracking on a test account without any issue by using a T-SQL statement: http://msdn.microsoft.com/en-us/library/bb964713.aspx
