SQL Server Error Code – 20670 cannot add, drop, or alter the identity

In this blog post, you’ll learn more about the SQL Server Error Code 20670 and the error message description that is shown

SQL Server Error Code

20670

SQL Server Error Description for the Code :20670

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.