471,616 Members | 1,259 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,616 software developers and data experts.

Can REPLICATION on SQL Server 2000 allow dirty reads

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.

Thanks.

Dec 1 '05 #1
1 1558
lo***********@yahoo.com (lo***********@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Dec 1 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Craig HB | last post: by
19 posts views Thread by Thue Tuxen Sørensen | last post: by
1 post views Thread by Andrew Chanter | last post: by
3 posts views Thread by Juan Antonio Villa | last post: by
1 post views Thread by mmark751969 | last post: by
1 post views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
1 post views Thread by ZEDKYRIE | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.