False Primary Key violations

• Andy Stephenson-354717

  SSC Enthusiast

  Points: 124

  More actions

  February 1, 2010 at 7:11 am

  #144568

  Hi - using SQL2005 Standard SP2.

  I've had a number of instances of very basic inserts failing (300,000 rows) with PK violation error. I run sp_updatestats & hey presto, the insert works just fine. Is this a know bug I can fix with SP3? I've had it occur 3 times now in production (same server, different databases), & the update stats makes it work just fine.

  Andy

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  February 1, 2010 at 7:17 am

  #1111600

  Can you post the DDL ?

  When you repost the data , is it EXACTLY the same data in EXACTLY the same order ?

  ---

  
  Clear Sky SQL
  My Blog[/url]