• IDENTITY_INSERT won't fix the issue of duplicate id coming from different offices.

    If IDENTITY_INSERT allowed you to introduce a duplicate id despite the PK constraint, what happens to related rows in other tables? ...chaos!

    Chris