insert into numeric primary key column in MSSQL

SET IDENTITY_INSERT [dbo].[MyTable] ON should allow you to insert into an auto incrementing numeric key field and you could turn this ability (dangerous) back off with something like SET IDENTITY_INSERT [dbo].[MyTable] OFF