- You have a table that has two or more bit data type columns in Microsoft SQL Server 2008 R2.
- You create a clustered index that contains two or more bit data type columns on the table.
- You create a nonclustered index on any column and specify the DATA_COMPRESSION option.
Index '<Index Name>' was not created. This index has a key length of at least -<Length> bytes. The maximum permissible key length is <Length> bytes.
Article ID: 2957174 - Last Review: 30 Jun 2014 - Revision: 1