mssqlserver-1904-database-engine-error.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords
MSSQLSERVER_1904	MSSQLSERVER_1904	MashaMSFT	mathoma	04/04/2017	sql	supportability	reference	1904 (Database Engine error)

MSSQLSERVER_1904

[!INCLUDE SQL Server]

Details

Attribute	Value
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.

Explanation

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

User Action

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.

See Also

CREATE INDEX (Transact-SQL)
CREATE STATISTICS (Transact-SQL)