FIX: Query Timeout of Replication Tasks Not In Seconds (153990)



The information in this article applies to:

  • Microsoft SQL Server 6.0
  • Microsoft SQL Server 6.5

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.

Modification Type:MajorLast Reviewed:10/16/2003
Keywords:kbfix kbusage KB153990