SQL Server Errors or Failures from Error: 20606 to Error: 20625

 

Error: 20606, Severity: 10, Reinitialized subscription(s).
Error: 20607, Severity: 10, Cannot make the change because a snapshot is already generated. Set @force_invalidate_snapshot to 1 to force the change and invalidate the existing snapshot.
Error: 20608, Severity: 10, Cannot make the change because there are active subscriptions. Set @force_reinit_subscription to 1 to force the change and reinitialize the active subscriptions.

Error: 20609, Severity: 16, Cannot attach subscription file ‘%s’. Make sure that it is a valid subscription copy file.
Error: 20610, Severity: 16, Cannot run ‘%s’ when the Log Reader Agent is replicating the database.
Error: 20611, Severity: 16, Cannot add the article. Publications that allow transformable subscriptions with Data Transformation Services (DTS) can only include tables and indexed views that are published as tables.
Error: 20612, Severity: 16, Checksum validation is not supported because the publication allows DTS. Use row count only validation.

Error: 20613, Severity: 16, Validation is not supported for articles that are set up for DTS horizontal partitions.
Error: 20614, Severity: 16, Validation is not supported for heterogeneous Subscribers.
Error: 20615, Severity: 16, Unable to add a heterogeneous subscription to the publication. The publication is not enabled for heterogeneous subscriptions.
Error: 20616, Severity: 10, High Volume Server-to-Server Profile
Error: 20617, Severity: 10, Merge agent profile optimized for the high volume server-to-server synchronization scenario.
Error: 20618, Severity: 16, You must have CREATE DATABASE permission to attach a subscription database.
Error: 20619, Severity: 16, Server user ‘%s’ is not a valid user in database ‘%s’. Add the user account or ‘guest’ user account into the database first.
Error: 20620, Severity: 11, The security mode specified requires the server ‘%s’ to be registered as a linked server. Use sp_addlinkedserver to add the server.
Error: 20621, Severity: 11, Cannot copy a subscription database to an existing database.
Error: 20622, Severity: 11, Replication database option ‘sync with backup’ cannot be set on the publishing database because the database is in Simple Recovery mode.
Error: 20623, Severity: 11, You cannot validate article ‘%s’ unless you have ‘SELECT ALL’ permission on table ‘%s’.
Error: 20624, Severity: 16, The value specified for the @login parameter is not valid. User ‘%s’ is not a user in database ‘%s’. Add the user account to the database before attempting to execute the stored procedures sp_grant_publication_access or sp_revoke_publication_access.
Error: 20625, Severity: 16, Cannot create the merge replication publication access list (PAL) database role for publication ‘%s’. This role is used by replication to control access to the publication. Verify that you have sufficient permissions to create roles in the publication dat

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.

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