begin
set identity_insert SpProductionDB.dbo.TSTD_ShortTermDisabilityCheck on
insert into SpProductionDB.dbo.TSTD_ShortTermDisabilityCheck
select *
from SpProductionDBBak.dbo.TSTD_ShortTermDisabilityCheck
set identity_insert SpProductionDB.dbo.TSTD_ShortTermDisabilityCheck off
end
Why does this not work, I am getting this error
**
Msg 8101, Level 16, State 1, Line 3
An explicit value for the identity column in table 'SpProductionDB.dbo.TSTD_ShortTermDisabilityCheck' can only be specified when a column list is used and IDENTITY_INSERT is ON.
**
Why doesn't Identy insert work
Posted - 08/03/2007 : 14:42:47
