1904

Product

Name

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.

ﾉ

Expand table