Hi all,
I am trying to do a very simple thing: remove the association between a table and a partition scheme.
I have my PK which is using a PS and I can't modify or drop it because it is not considered as an index and I have no other idea on how to unpartition the table.
MS suggests I merge all partitions which doesn't do the job because the table is still mapped to he Partition Scheme (the table is physically unpartitioned but I can't for instance make it use a different PS)...
I can't believe such a simple task doesn't have a simple solution.
Thanks!