IT:AD:SQL Server:HowTo:Insert Ids into Int Identity Columns
Summary
The basis behind one technique for syncing remote databases:
SET IDENTITYINSERT ReseedDemo ON INSERT ReseedDemo (Id,X) VALUES (1000022,'A') SET IDENTITYINSERT ReseedDemo OFF DBCC CHECKIDENT (ReseedDemo, RESEED, 21)