Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
parody
Posting Yak Master
111 Posts |
 Posted - 2010-07-22 : 09:57:18
|
| Hi I am trying to write a simple partition switch from a staging table to the main data table and encountering error 7733: 'ALTER TABLE SWITCH' statement failed. The table 'x' is partitioned while index 'x' is not partitioned. I understand what the error is telling me, but surely this is a major limitation of the switch functionality? In order to partition the nonclustered primary key in on the same sheme I would need to include the partitioned column in the index, but that would prevent the primary keys usefulness in preventing dupes across the true key columns, allowing dupes across the partition column. Am I missing something?! |
|
|
parody
Posting Yak Master
111 Posts |
|
|
rasadovsky
Starting Member
1 Post |
Posted - 2014-11-07 : 13:21:19
|
| SQL 2012 despite expectations has the same limitations.Nothing changed since 2010 :(Have you been able to work around somehow? |
 |
|
|
|
|
|
Table Partitioning Issue