Knowledge Base

FIX: Query Timeout of Replication Tasks Not In Seconds

Article ID: 153990

Article Last Modified on 10/16/2003

APPLIES TO

This article was previously published under Q153990

SYMPTOMS

The SQL Server documentation states that the query timeout option (-q) of replication tasks (logreader, distribution) is in seconds. Actually, it is in milliseconds.

RESOLUTION

To work around this problem, specify the desired timeout value for the -q parameter of the replication tasks in milliseconds.

To correct this problem, upgrade to SQL Server 6.5 Service Pack 1.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 6.0 and 6.5. This problem was corrected in U.S. Service Pack 1 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.

Additional query words: logreader distribution timeout

Keywords: kbfix kbusage KB153990


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.