sys-sysmessages-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs
sys.sysmessages (Transact-SQL)	sys.sysmessages (Transact-SQL)	rwestMSFT	randolphwest	03/15/2017	sql	system-objects	reference	sys.sysmessages sysmessages sysmessages_TSQL sys.sysmessages_TSQL	sysmessages system table sys.sysmessages compatibility view	TSQL

sys.sysmessages (Transact-SQL)

[!INCLUDE SQL Server]

Contains one row for each system error or warning that can be returned by the [!INCLUDEssDEnoversion]. The [!INCLUDEssDE] displays the error description on the user's screen.

Important

[!INCLUDEssnoteCompView]

Column name	Data type	Description
error	int	Unique error number.
severity	tinyint	Severity level of the error.
dlevel	smallint	[!INCLUDEssInternalOnly]
description	nvarchar(255)	Explanation of the error with placeholders for parameters.
msglangid	smallint	System message group ID.

See Also

Mapping System Tables to System Views (Transact-SQL)
Compatibility Views (Transact-SQL)