September 5, 2001 at 9:56 am
I have a merge replication and in one table I can't insert new rows on the suscriber. SQL Server says that the identities interval is full, but I don't know how to reserve another interval. The replication runs without problems.
Sorry for my poor english and thanks.
Edited by - sergiofg on 09/05/2001 10:03:32 AM
September 5, 2001 at 7:54 pm
Looks like its a bug - take a look at this article:
http://support.microsoft.com/support/kb/articles/Q304/7/06.ASP
Gives explanation and a couple options, one of which is to use Sp_adjustpublisheridentityrange.
Andy
September 6, 2001 at 5:03 am
That was not my problem. This bug refer to an error on the publisher in continuos replication, and my problem was in the suscriber and I use scheduled replication.
The problem is that some tables have two checks restrictions repl_identity_range_sub_,
deleting one of them correct the problem.
is this dangerous? could i have more problems becouse of this?
thanke you
Edited by - sergiofg on 09/06/2001 05:04:12 AM
September 6, 2001 at 5:22 am
What is your identity column set to right now? Is it over 2 billion? You may have to reseed that or the system table that logs the intervals.
Brian Knight
http://www.sqlservercentral.com/columnists/bknight
Brian Knight
Free SQL Server Training Webinars
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply