Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Table Locks during synchronization?

Author  Topic 

Ken Blum
Constraint Violating Yak Guru

383 Posts

Posted - 2009-09-22 : 15:58:27
Can anyone tell me if any tables in the articles of publication are locked during a synchronization of a merge replication?

krishnarajeesh
Yak Posting Veteran

67 Posts

Posted - 2009-11-04 : 02:53:47
Row level locking happens on update command by merge agent. Table level lock happens only in the initial time, when we setup the merge replication.

Thanks,
Krishna
www.SQLServer.in
Go to Top of Page
   

- Advertisement -