Posted by loosecannon_1@yahoo.com on 10/23/60 11:33

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.

• Next in forum: Re: Bulk delete on operational data
• Prev in forum: Re: STORED PROCEDURE - passing table name as a parameter
• Thread view: Can REPLICATION on SQL Server 2000 allow dirty reads

[Reply to this message]