Sync tracking tables are deadlocking database RRS feed

  • Question

  • I have an issue. I setup Microsoft sync to sync data between SQL Express 2014 Client databases and a SQL Server 2008 R2 database. I setup templates on the server so when a user connects to the server it creates scope on the client and then check to see if scope exist on server. The issue is when the client checks the server the scope already exist but the client tries to create stored procedures anyway. This is causing a deadlock on the server. Please help.


    Friday, July 29, 2016 8:50 PM