FIX: Query Timeout of Replication Tasks Not In Seconds

ID: Q153990


The information in this article applies to:


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          : kbusage SSrvDoc_Err SSrvRep kbbug6.00 
Version           : 6.0 6.5
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: March 31, 1999