I wonder if I can have a table like that:

Create table ORDERS (
Ordered int primary key nonclustered,
Orderdate datetime,
Orderdata varchar(100) )

and to partition it by the OrderDate field.

It does not allow me to exclude the partitioning field out from primary key constraint.

Any ideas?

Thanks