Solution :
Your error message basically says it all. You either of the below things:
·You can make a column list (a SELECT on the INFORMATION_SCHEMA.COLUMNS and the good text editor)
·You can make the identity column in your tbl_A_archive the regular (non-identity) int column (since it is the archive table, why do you want the identity column?).
OR
You can try below option
SET IDENTITY_INSERT tableA ON
You have to make your column list for the INSERT statement as shown below:
INSERT Into tableA ([id], [c2], [c3], [c4], [c5] )
SELECT [id], [c2], [c3], [c4], [c5] FROM tableB
It is not like a "INSERT Into tableA SELECT"
SET IDENTITY_INSERT tableA OFF
I hope above mentioned solutions will help you in fixing your errors.