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
>>