I got it. The INSERT INTO was missing the draft status id field and also the name in the new table was still DRAFT_STATUS_ID but labeled Draft Status Id.

Arthur Fuller explores the value of identity columns and the usefulness of their arbitrary values and discusses ways to use SQL Server 2000's IDENTITY_INSERT setting. Despite your numerous ...

Microsoft's SQL Server software, used in thousands of businesses ranging from storefront operations to multinational companies, has capabilities to bulk-insert Comma Separated Value files into a ...

When you insert new records into an SQL database, you may run into issues where you accidentally overwrite records that are already present due to a duplication issue. You can use a simple alteration ...