Help! can't insert to table! with two primary key

[Cerebrate]

I try to insert couple data into a table which has two primary key. It's very strange!
I can insert the only two at once and I will receive these error right after the second row is insert:
"violation of primary key contraint XXXXX , can not insert dulplicate key into object XXXX."

Please help me!!


Cerebrate

[Ianpbaker]

Sorry If this Is A stupid question But when your entering your two rows, have you got the two primary keys different For both inserts because if you haven't it will cause the error you are getting.

EG. If both your keys were numeric you could have 1,1 For one record and 1,2 for the next, But you couldn't have 1,1 in any other record.

Again sorry if this is a stupid question but i'm just eliminating the obvious.


Hoep this helps

Ian