Cannot alter table 'TableName' because the table either contains sparse columns or a column set column which are incompatible with compression.
- You use the REBUILD argument together with the ALTER TABLE statement.
- You use the REBUILD argument together with the ALTER INDEX statement and specify the DATA_COMPRESSION = NONE option in the statement.
For more information about what files are changed, and for information about any prerequisites to apply the cumulative update package that contains the hotfix that is described in this Microsoft Knowledge Base article, click the following article number to view the article in the Microsoft Knowledge Base:
Article ID: 958792 - Last Review: May 17, 2010 - Revision: 1