Microsoft KB Archive/322667

= DOC: SQL Server Books Online Includes Incorrect Documentation on Distribution Agent Profile Parameters in Transactional Replication =

Article ID: 322667

Article Last Modified on 11/14/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q322667



BUG #: 355378 (SHILOH_BUGS)



SUMMARY
There are two problems in SQL Server 2000 Books Online documentation about the Distribution Agent profile in transactional replication:
 * 1) In SQL Server 2000 Books Online, the default Distribution Agent profile includes parameter SkipFailureLevel = 1, which means the Distribution Agent ignores errors; however, in Enterprise Manager, under Replication Monitor, the Distribution Agent &quot;default profile&quot; or &quot;new&quot; does not show this parameter. In Enterprise Manager, you cannot add this parameter either.
 * 2) In SQL Server 2000 Enterprise Manager, under Replication Monitor, the Distribution Agent default or new profile includes the KeepAliveMessageInterval parameter. This parameter is not documented in SQL Server 2000 Books Online for the Distribution Agent profile. SQL Server Books Online incorrectly states that this parameter is only available to the Merge Agent.

To add the -SkipFailureLevel parameter:
 * 1) Right-click the Distribution Agent, and then click Agent properties.
 * 2) On the Steps tab, double-click the Run Agent job step.
 * 3) In the Command box, at the end of the command, add the parameter -SkipFailureLevel 1 or 0, click Apply, and then restart this Distribution Agent job to let the new configuration take affect.

The KeepAliveMessageInterval parameter information is documented in the Distribution Agent Profile in the SQL Server 2000 Books Online refresh.

To download the refresh, visit the following Microsoft Web site:

http://technet.microsoft.com/en-us/sqlserver/bb331756.aspx



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

This problem is specific to the Books Online documentation for the Microsoft products that are listed in the beginning of this article.

Keywords: kbbug kbpending KB322667

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.