10737

Product

Name

MSSQLSERVER

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 = WITH

(DATA_COMPRESSION={ON | OFF}).

ﾉ

Expand table