79697637

Date: 2025-07-10 21:59:14
Score: 2
Natty:
Report link

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.

Reasons:
  • No code block (0.5):
  • Single line (0.5):
  • Low reputation (1):
Posted by: JR Cardwell