primary key constraint violation

• Question

• 

  

  0

  Sign in to vote

  i have a table with two fields, they are the PK...
  i write data from firebird to sql....
  
  there ARE NO duplicates in the firebird data...
  when i write to sql i get:
  
  

  Violation of PRIMARY KEY constraint 'PK_ACCESSLEVELS'. Cannot insert duplicate key in object 'dbo.ACCESSLEVELS'.

  The statement has been terminated.

  
  why is this?
  
  thank you
  helloise

  • Moved by Peter Ritchie Thursday, September 4, 2008 3:16 PM SQL question (Moved from Visual C# Language to Off-Topic Posts (Do Not Post Here))

  Wednesday, September 3, 2008 2:08 PM