Export (0) Print
Expand All

MSSQLSERVER_1904

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Product Name

SQL Server

Event ID

1904

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

KEYCOUNT

Message Text

The %S_MSG '%.*ls' on table '%.*ls' has %d column names in %S_MSG key list. The maximum limit for index or statistics key column list is %d.

The key column list for the specified index or statistics exceeds the maximum number of columns allowed.

Modify the key column list to include no more than the specified maximum number of columns.

For nonclustered indexes, consider using the INCLUDE clause in the CREATE INDEX statement to add columns to the index as nonkey columns. This method avoids exceeding the current index size limitation of a maximum of 16 key columns. For more information, see Create Indexes with Included Columns.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft