Home Dashboard Directory Help
Search

Identity Range not working for Queued Updating Replication in SQL Server 2005 and 2008 by Jason Qu


Status: 

Active


1
1
Sign in
to vote
Type: Bug
ID: 777364
Opened: 1/24/2013 2:18:35 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

We have a table on our publisher that seems to be filling up it's identity
ranges periodically. It seems as though when it does fill up its
range of values that it doesn't get its new ranges soon enough and users
experience the error "The insert failed. It conflicted with an identity range
check constraint". I reproduced this error both on SQL 2005 and 2008 editions.
Details
Sign in to post a comment.
Posted by Microsoft on 1/30/2013 at 11:35 AM
Hi Jason,
    
thanks for taking the time to share your feedback, this is really important to us.
We will investigate the issue and get back to you.

Best regards
Jean-Yves Devant 

Program Manager Servicing and Lifecycle Experience of High Availability Technologies in SQL Server
Sign in to post a workaround.