MSSQLSERVER_10737
Details
Product Name |
MSSQLSERVER |
Product Version |
11.0 |
Product Build Number |
11 |
Event ID |
10737 |
Event Source |
MSSQLSERVER |
Component |
SQLEngine |
Symbolic Name |
REBUILD_PARTITION_ALL_NOT_SPECIFIED |
Message Text |
In an ALTER TABLE REBUILD or ALTER INDEX REBUILD statement, when a partition is specified in a DATA_COMPRESSION clause, PARTITION=ALL must be specified. The PARTITION=ALL clause is used to reinforce that all partitions of the table or index will be rebuilt, even if only a subset is specified in the DATA_COMPRESSION clause. |
User Action
Add the PARTITION=ALL clause to the ALTER TABLE or ALTER INDEX statement. Or, to rebuild a specific partition, use REBUILD PARTITION = <partition-number-expr> WITH (DATA_COMPRESSION={ON | OFF}).