Table Partiotining on an exsisting table with clustred index.

• dedicatedtosql

  Ten Centuries

  Points: 1147

  More actions

  October 29, 2012 at 3:59 pm

  #264086

  Hi All,

  I am trying to partion an existing table in our environment. The issue is it alredy has a clustred index on it. There are other tables that reference the prmary key. I was told that I had to drop the clustred index and then create it and in the ON clause I should give the Partition Scheme name. But I keep getting an error when I do this.

  Column 'CreatedDate' is partitioning column of the index 'PK_tblBatchItemToProcess'. Partition columns for a unique index must be a subset of the index key.

  I just dont understand what I am doing wrong.

  Any idea would be grateful.

  Regards

• Alexander Suprun

  SSCertifiable

  Points: 6253

  More actions

  October 29, 2012 at 4:22 pm

  #1553947

  What part of the message you don't understand?

  You have to put CreatedDate into keys of your index.

  ---

  Alex Suprun