InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 15:39:59 GMT20http://www.sqlservercentral.com/Forums/Topic1304724-2572-1.aspxI have two databases one is onpremise and other is on Sql Azure and i have createa sync group that synchronize a table from on premise to azure as bidirectional syncthat table has 7 crore rows and the sync run approx 8 to 9 hours and at random my tablegets lock and i am not able to select any row from that table.plz suggest me why dedlock occur and how to prevent this lock.Whats going worng is there any other way to synchrinize my table from onpremise to azure database.Thanks!!Wed, 23 May 2012 00:48:18 GMTshubham.saxena67