The process as I understand it is:

The trigger runs after the insert transaction, whether that involves inserting one record or many - hence the problem with the '=' and inserting...

Martin,

I was going to disagree on the statement 'If the last used identity is exactly on the last value in the 1st range' as I thought it did a '>='...

It seems a reply I posted a couple of weeks ago didn't make it. I'll give an abridged version.

After thinking more on this I'm now thinking Noelds approch of...

alex (1/14/2009)

---

We've been struggling with the same issues we're an MCP so we raised a ticket as MS....

Its been raised on this forum before

http://www.sqlservercentral.com/Forums/Topic339239-291-1.aspx#bm339851

Thank you for contacting Microsoft SQL...

Although Merge Replication is not my most used method I have to tell you that "automatic identity management" works only as well as you could possibly plan to unexpected behavior...