Posted by Erland Sommarskog on 10/23/34 11:33

loosecannon_1@yahoo.com (loosecannon_1@yahoo.com) writes:
> All my queries are being blocked while the tables are being replicated
> and it is causing some 2 minute blocking. Is there a way for the
> Replication to allow dirty reads because I really don't care about
> that, I would rather have dirty reads than 2 minute waits.

I will have to admit that I am not very experienced with replication, but
this sounds very strange to me. Replication is done from the transaction
log, so there is no blocking reads.

Or are we talking merge replication? That I know even less about.

microsoft.public.sqlserver.replication may be a better place to ask.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Extracting and joining header from denormalized table
• Prev in forum: Re: Help needed by deadlock problem
• Thread view: Re: Can REPLICATION on SQL Server 2000 allow dirty reads

[Reply to this message]