Sql Server 2008 Partitioning + Identity Column Constraint Issue <p>I have a table containing huge amount of data I decided to do the partitioning on that table But I am getting some sort of issues please clarify them.</p> <p>I have an identity column as a primary key ID (int type).</p> <p>I have done the partitioning by the date column making it also primary key with the combination of <code>ID + date</code>.</p> <p>Problem is that I am not able to insert the records in partitioning tables because the partitioning view is not able to insert the data due to the identity constraint. Please help Me.</p>