Error 1904

Troubleshooting SQL Server

Troubleshooting

Error 1904

Severity Level 16
Message Text

Cannot specify more than %d column names for statistics or index key list. %d specified.

Explanation

This error occurs when more than 16 columns are used to create a composite index. A composite index is an index that uses from 2 to 16 columns.

The following example shows a composite index using objects from the pubs database:

USE pubs
GO
CREATE INDEX idxPubNameCity
ON publishers (pub_name, city)
GO
Action

Modify the CREATE INDEX statement to use no more than 16 columns. For more information, see CREATE INDEX.

See Also

Creating an Index

Errors 1000 - 1999