I've been trying to implement the Table Partitioning feature of SQL Server 2005, however I'd like to do it by using an existing table. So far I've done the following: 1. Created Files and specified their Filegroups. 2. Created Partition Function specifying it would apply to DateTime type, and specified Ranged of values. 3. Created Partition Scheme referencing my partition function. The last thing for me to do is have the actual connection from the column of my table to my partition scheme. Most of the examples I've seen such as this article on BOL http://msdn2.microsoft.com/en-us/library/ms345146.aspx#sql2k5parti_topic8) were creating new tables. In this article http://www.databasejournal.com/features/mssql/article.php/3647561) they move the table to a new partition by creating a clustered index. I read that it'll work that way at another location as well. The statement they used was Drop index MyTable_IXC on MyTable with (Move To [Data Partition Scheme] (ID) ) However, this format doesn't seem to work for me. I receive the following error: Msg 3723, Level 16, State 4, Line 1 An explicit DROP INDEX is not allowed on index 'STAY.STAYPRIMARY'. It is being used for PRIMARY KEY constraint enforcement. AS you can see, my primary key and clustered index are the same for this table. Any ideas on how I can get this table partitioned with the data in it?