I TRY TO EXECUTE THIS SCRIPT VIA QUERY ANALYZER:
GO
SET IDENTITY_INSERT [IdWare].[dbo].[CPU] ON
GO
INSERT INTO [IdWare].[dbo].[CPU]
SELECT id,ServerName,LogConsumer,WeekType,IsMaster,TransactionConsumer,null,null
FROM [IdWareOld].[dbo].[CPU]
GO
SET IDENTITY_INSERT [IdWare].[dbo].[CPU] OFF
GO
THE RESULT IS:
Server: Msg 545, Level 16, State 1, Line 1
Explicit value must be specified for identity column in table 'CPU' when IDENTITY_INSERT is set to ON.
GO
SET IDENTITY_INSERT [IdWare].[dbo].[CPU] ON
GO
INSERT INTO [IdWare].[dbo].[CPU]
SELECT id,ServerName,LogConsumer,WeekType,IsMaster,TransactionConsumer,null,null
FROM [IdWareOld].[dbo].[CPU]
GO
SET IDENTITY_INSERT [IdWare].[dbo].[CPU] OFF
GO
THE RESULT IS:
Server: Msg 545, Level 16, State 1, Line 1
Explicit value must be specified for identity column in table 'CPU' when IDENTITY_INSERT is set to ON.