ID Number: Q78815
1.10 1.11
OS/2
buglist1.11
Summary:
Problem ID: PRSQL9112002
SYMPTOMS
When attempting to create a composite clustered index on 17
columns, SQL Server does not return an error.
CAUSE
The maximum number of columns allowed in a single index is 16.
Attempting to create an index on more than 16 columns should result
in an error from SQL Server. However, SQL Server incorrectly
accepts a CREATE INDEX statement that creates a clustered index on
17 columns. Attempting to create the index on more than 17 columns
results in the expected error (error message #1904).
This problem occurs only when creating clustered indexes.
Attempting to create a nonclustered index on 17 columns results in
the expected error.
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.