ID Number: Q78812
1.11
OS/2
buglist1.11
Summary:
Problem ID: PRSQL9110001
SYMPTOMS
When attempting to create a composite index with more than 16
columns, SQL Server displays the following error (Msg 1904, Level
16, State 1)
Cannot specify more than 17 column names for index key list.
<number> specified.
where <number> is one larger than the number of columns specified
in the CREATE INDEX statement, if a nonclustered index is being
created. <number> will be correct if a clustered index is being
created.
CAUSE
SQL Server incorrectly displays both the maximum number of columns
that can be in an index and the number of columns specified.
The maximum number of columns that can be in a composite index is
16; not 17 (as stated in the error message).
STATUS
Microsoft has confirmed this to be a problem in SQL Server version
1.11. This problem does not occur in SQL Server version 4.2.
Additional reference words: 1904