| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |
|---|---|---|---|---|---|---|---|---|---|
MSSQLSERVER_10737 |
MSSQLSERVER_10737 |
MashaMSFT |
mathoma |
04/04/2017 |
sql |
supportability |
reference |
|
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance]
| Attribute | Value |
|---|---|
| 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 = <partition-number-expr> WITH (DATA_COMPRESSION={ON | OFF}).