Description
ALTER TABLE EXCHANGE requires a non-partitioned, non-clustered table
Cause
The table in the EXCHANGE operation is either clustered or partitioned
Solution/Action
Ensure that the table with which the partition is being exchanged for is not partitioned or clustered.
Commnets