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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Partition Index Page Level Compression

Author  Topic 

GhantaBro
Posting Yak Master

215 Posts

Posted - 2010-02-27 : 20:03:03
Guys I was trying to do a page level compression on a table in sql server 2008... this is the error I got... Guys should I rebuild the index? Any suggestion.. thanks.

Msg 7733, Level 16, State 2, Line 3
'ALTER TABLE' statement failed. The table 'MyTable' is partitioned while index 'MyIndex_IDX' is not partitioned.

Table has 7 partitions... how can I partition the index that is already there?
   

- Advertisement -