SQL Server Errors or Failures from Error: 21074 to Error: 21101
Error: 21074, Severity: 16, The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.
Error: 21075, Severity: 10, The initial snapshot for publication ‘%s’ is not yet available.
Error: 21076, Severity: 10, The initial snapshot for article ‘%s’ is not yet available.
Error: 21077, Severity: 10, Deactivated initial snapshot for anonymous publication(s). New subscriptions must wait for the next scheduled snapshot.
Error: 21078, Severity: 16, Table ‘%s’ does not exist in the Subscriber database.
Error: 21079, Severity: 16, The RPC security information for the Publisher is missing or
invalid. Use sp_link_publication to specify it.
Error: 21080, Severity: 16, The ‘msrepl_tran_version’ column must be in the vertical partition of the article that is enabled for updatable subscriptions; it cannot be dropped.
Error: 21081, Severity: 16, Server setting ‘Allow triggers to be fired which fire other triggers (nested triggers)’ must exist on updatable Subscribers.
Error: 21082, Severity: 16, Database property ‘IsRecursiveTriggersEnabled’ has to be false for subscription databases at Subscribers that allow updatable subscriptions.
Error: 21083, Severity: 16, Database compatibility level at immediate updating Subscribers cannot be less than 70.
Error: 21084, Severity: 16, Publication ‘%s’ does not allow anonymous subscriptions.
Error: 21085, Severity: 16, The retention period must be less than the retention period for the distribution database.
Error: 21086, Severity: 16, The retention period for the distribution database must be greater than the retention period of any existing non-merge publications.
Error: 21087, Severity: 16, Client subscriptions and anonymous subscriptions cannot republish data. To republish data from this database, the subscription to the root Publisher must be a server subscription with a priority greater than 0. Drop the current subscription and create a s
Error: 21088, Severity: 10, The initial snapshot for the publication is not yet available.
Error: 21089, Severity: 16, Only members of the sysadmin fixed server role can perform this operation.
Error: 21090, Severity: 16, Cannot upgrade merge replication metadata. Attempt the upgrade again by running the Merge Agent for the Subscriber or by running the Snapshot Agent for the Publisher.
Error: 21091, Severity: 16, Global subscribers with priority 0 are not allowed to create merge publications.
Error: 21092, Severity: 10, The Change Tracking manual cleanup procedure for database %s has been executed
Error: 21101, Severity: 10, The custom command name %s specified for parameter %s will be ignored. A system generated name will be used instead. The publication allows %s and command names need not be specified.
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.