Export (0) Print
Expand All
Expand Minimize

MSSQLSERVER_10737

Product Name

MSSQLSERVER

Product Version

10.50

Product Build Number

10.00.1399.60

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.

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}).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft