SQL Server Errors or Failures from Error: 20542 to Error: 20565



Error: 20542, Severity: 10, Detects and removes expired subscriptions from published databases.
Error: 20543, Severity: 10, @rowcount_only parameter must be the value 0,1, or 2. 0=7.0 compatible checksum. 1=only check rowcounts. 2=new checksum functionality introduced in version 8.0.
Error: 20545, Severity: 10, Default agent profile
Error: 20546, Severity: 10, Verbose history agent profile.
Error: 20547, Severity: 10, Agent profile for detailed history logging.
Error: 20548, Severity: 10, Slow link agent profile.

Error: 20549, Severity: 10, Agent profile for low bandwidth connections.
Error: 20550, Severity: 10, Windows Synchronization Manager profile
Error: 20551, Severity: 10, Profile used by the Windows Synchronization Manager.
Error: 20552, Severity: 10, Could not clean up the distribution transaction tables.
Error: 20553, Severity: 10, Could not clean up the distribution history tables.
Error: 20554, Severity: 10, The replication agent has not logged a progress message in %ld minutes. This might indicate an unresponsive agent or high system activity. Verify that records are being replicated to the destination and that connections to the Subscriber, Publisher, and D

Error: 20555, Severity: 10, 6.x publication.
Error: 20556, Severity: 10, Heartbeats detected for all running replication agents.
Error: 20557, Severity: 10, Agent shutdown. For more information, see the SQL Server Agent job history for job ‘%s’.
Error: 20558, Severity: 10, Table ‘%s’ passed full rowcount validation after failing the fast check. DBCC UPDATEUSAGE will be initiated automatically.
Error: 20559, Severity: 10, Conditional Fast Rowcount method requested without specifying an expected count. Fast method will be used.
Error: 20560, Severity: 10, An expected checksum value was passed, but checksums will not be compared because rowcount-only checking was requested.
Error: 20561, Severity: 10, Generated expected rowcount value of %s for %s.
Error: 20565, Severity: 10, Replication: Subscriber has failed data validation

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.


Leave a Reply

Your email address will not be published. Required fields are marked *