One other gotcha - I used right-click -> script table as insert to... and used that for the import from a backup table, but still got the error even with SET IDENTITY_INSERT tablename ON, because the script creation automatically skipped the identity column. Insert succeeded once I add the column back into the insert and select parts of the statement.