July 25, 2008 at 1:36 am
Hi,
Can anyone help urgently??
I have to roll back a table in sqlserver 2005, where in table for one column the "Set Identity Insert" is "ON".
Before making change in the table i have taken the backup of that table, now when I am trying to truncate the main table and inserting the data from the backuped table I am getting the error
"Msg 8101, Level 16, State 1, Line 1
An explicit value for the identity column in table 'jv_nfa' can only be specified when a column list is used and IDENTITY_INSERT is ON."
Vishwajeet
July 25, 2008 at 1:58 am
go2vish (7/25/2008)
Hi,Can anyone help urgently??
I have to roll back a table in sqlserver 2005, where in table for one column the "Set Identity Insert" is "ON".
Before making change in the table i have taken the backup of that table, now when I am trying to truncate the main table and inserting the data from the backuped table I am getting the error
"Msg 8101, Level 16, State 1, Line 1
An explicit value for the identity column in table 'jv_nfa' can only be specified when a column list is used and IDENTITY_INSERT is ON."
Vishwajeet
Use
SET IDENTITY_INSERT tablename ON
-- .. your statements
SET IDENTITY_INSERT tablename OFF
Regards,
Andras
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply