SQL Server Violation of Primary Key

[datawise]

I have a table, "SOME_TABLE", with a clustered primary key on a character column, "XYZ_ID". I copied this table to a temporary backup table using "select * into SOME_TABLE_BKUP from SOME_TABLE". Then I dropped and re-created the original table with the same table structure and primary key constraint. But when I try to insert data from the backup table, "insert into SOME_TABLE select * from SOME_TABLE_BKUP" I get a violation of primary key constraint error even though there are no duplicate primary key values. If I add the data without the primary key constraint then try to add the constraint I again get the error and it specifies a specific key value that it sees already exists but when I query the data for that specific key value there is only one record.

[gomathipriya]

is your Primary Key has an identity value in SOME_table? if yes, try to insert the data except the primary key, so that your table automatically gives the value to primary key column.