Now when I've tried it the past several times the range has updated (1 range at a time) on the subscriber if I'm into the second range.

It seems like it...

martin (2/10/2009)

---

If the identity makes it safely into the 2nd range (more likely if there is no gap), then the next time the merge agents runs, the ranges should get...

I understand the higher numbers are the "next_range", but look at the code below:

if IDENT_CURRENT('[dbo].[ActivityStats]') = @range_end

begin

...

if IDENT_CURRENT('[dbo].[ActivityStats]') = @range_end

begin

...

Ok, now I really don't know what's going on.

So this afternoon I got the same error "The insert failed. It conflicted with an identity range check constraint in database X"

So...

Ok, that makes sense.

The only way I can see to get around that is to have the "original" functionality where you have a value say 80% where if the first...

I see the stuff you're talking about in there.

Does anyone know what all the crap is beneath that? I can't see what the views look like (no option to...

I think we're fine on the multiple inserts.

Usually we have a batch of inserts, but they are not in the same statement (one stored procedure with one insert ran 10x)...

It looks like I am getting errors on both sides. Thanks for the note on the adjustrange, I was un-aware I could do it for a whole publication.

Is there...

Thanks for the reply. If someone here has existing code to update all of the tables it would be greatly appreciated. My desk is so full of stuff...

I just tripped on this forum while searching for the same issue and am very upset to find it has not been resolved with microsoft fully, especially as a flagship...