Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: The value for the @pub_identity_range parameter must be a multiple of the increment for the identity column. The increment for table “%s” and identity column “%s” is %s.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: The value for the @identity_range parameter must be a multiple of the increment for the identity column. The increment for table “%s” and identity column “%s” is %s.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: The value of IDENT_CURRENT (“%s”) is greater than the value in the max_used column of the MSmerge_identity_range system table.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: The republisher’s republishing range obtained from its publisher is not large enough to allocate the specified @pub_identity_range.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: The republisher’s republishing range obtained from its publisher is not large enough to allocate the specified @identity_range.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: The republisher does not have a range of identity values from the root Publisher ‘%s’ that it can assign to its Subscribers. Ensure that the republisher has a server subscription to the publication at the root Publisher, and then run the Merge Agent to synchronize with the root Publisher.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: The identity range allocation entry for the Publisher could not be found in the system table MSmerge_identity_range. Ensure that the value for the @identityrangemanagementoption property is “auto”.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: The Publisher cannot be assigned a new range of identity values, because the values for the identity column’s data type have all been used. Change the data type in the identity column.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: The republisher does not have a range of identity values from the root Publisher that it can assign to its Subscribers. Run the Merge Agent to synchronize with the root Publisher.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Cannot refresh the identity range and/or the check constraint on the Publisher. Ensure the following: that the value in the identity column has not reached the maximum for the data type in the identity column; and that the user who made the last insert has the privileges to drop and re-create the check constraint.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Cannot allocate an identity range for article “%s”. The article is not enabled for automatic identity range management.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Cannot add, drop, or alter the identity range check constraint for table %s. This constraint is used by replication for automatic identity range management. This error typically occurs if the user who made the last insert in the table does not have permission to make schema changes on the table. If this error occurs at the Publisher, run sp_adjustpublisheridentityrange; if it occurs at the Subscriber, run the Merge Agent.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Cannot find the identity range allocation entry for the Subscriber in the MSmerge_identity_range table. Reinitialize the subscription.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: A value for the parameter @host_name was specified, but no articles in the publication use HOST_NAME() for parameterized filtering.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: A value for the parameter @host_name was specified, but no articles in the publication use SUSER_SNAME() for parameterized filtering.

Microsoft SQL Server database ranks third in the r… Continue Reading Microsoft SQL Server: Cannot refresh the Publisher identity range for article “%s”. Execute the stored procedure sp_adjustpublisheridentityrange to refresh the identity range.