Home Forums SQL Server 2008 SQL Server Newbies import data with identity columns... RE: import data with identity columns...
Chris_M
Old Hand
Points: 326
More actions
March 11, 2013 at 11:53 am
#1595684
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