MSSQLSERVER_7711
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Details
Product Name |
SQL Server |
Event ID |
7711 |
Event Source |
MSSQLSERVER |
Component |
SQLEngine |
Symbolic Name |
PRT_RANGE_OVERLAP |
Message Text |
The DATA_COMPRESSION option was specified more thanĀ once for the table or index or one of its partitions. |
Explanation
An error occurred in the DATA_COMPRESSION option in one of the following statements:
CREATE TABLE
ALTER TABLE
CREATE INDEX
ALTER INDEX
If the table or index cited is partitioned, the DATA_COMPRESSION option was listed more than one time for at least one of the partitions. If the table or index is not partitioned, the DATA_COMPRESSION option was cited more than one time.
User Action
For a partitioned table or index, make sure that the DATA_COMPRESSION option is specified only one time for each partition. For a table or index that is not partitioned, use the DATA_COMPRESSION option only one time in the statement.