You can create a clustered index on a partitioned table if all of the following conditions are true:
The server is configured to run in parallel,
The select into/bulkcopy/pllsort database option is set to true, and
As many worker threads are available as the number of partitions.
However, to speed recovery, dump the database after creating the clustered index.
For more information about partitioned tables and creating clustered indexes on them, see the System Administration Guide. See a System Administrator or the Database Owner before creating a clustered index on a partitioned table.
