Alter Partition Function

• cathy.baker

  Hall of Fame

  Points: 3412

  More actions

  January 3, 2011 at 7:45 am

  #230006

  I have a database in which we partition a table using a calendar id which is an int referencing a date in a calendar table. Each year, I add another filegroup and multiple files to hold the new year's data and split the partition.

  Here is my partition function:

  ALTER PARTITION Function SDW_FactCashierEvents_Partition() Split Range (1462)

  My problem is that I am receiving the following error message:

  Cannot insert duplicate key row in object 'dbo.FactCashierEvents' with unique index 'IX_FactCashierEvents_LocationID'.

  The statement has been terminated.

  This index is NOT a unique index. It is a non-unique, nonclustered index. I've already dropped and re-created the index.

  Has anyone else had this issue or can offer a suggestion?

• Henry Treftz

  SSCarpal Tunnel

  Points: 4207

  More actions

  January 3, 2011 at 11:52 am

  #1268602

  A bit of a shot in the dark here but it might be worth it to.

  sp_recompile on your table

  and

  dbcc checkcatalog