SQL Server 2005: Aligning indexes with partitioned table

I'm attempting to align an index with a partitioned table, but the partition key column is nullable in the table definition.

In order to align the indexes I have to make this field not null, but when I attempt to alter the column on the table I receive an error saying that the table depends on that开发者_开发知识库 field.

---

You will need to remove the partition scheme from that table, correct the data issue, then repartition.

Or, create a new, properly partitioned version of the table with the right constraints and put your data into it from the old table.