Right, you also have to list all the columns in the INSERT.

>Same result
>
>>In order to allow inserts in an IDENTITY column, you have to set

SET IDENTITY_INSERT result_detail ON

>>
>>
>>>I made a copy of a table for backup purposes. I now want to restore from it:
>>>
>>>

>>>insert into result_detail
>>>  select * from result_detail_old
>>>

>>>
>>>SQL throws:
>>>"An explicit value for the identity column in table 'result_detail' can only be specified when a
>>>column list is used and IDENTITY_INSERT is ON."
>>>
>>>I tried SET IDENTITY_INSERT result_detail OFF
>>>