469,299 Members | 2,073 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,299 developers. It's quick & easy.

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 1490
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
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.