{"id":82,"date":"2011-12-20T08:47:05","date_gmt":"2011-12-20T08:47:05","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2011\/12\/20\/sql-server-error-messages-list\/"},"modified":"2011-12-20T08:47:05","modified_gmt":"2011-12-20T08:47:05","slug":"sql-server-error-messages-list","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2011\/12\/20\/sql-server-error-messages-list\/","title":{"rendered":"SQL Server Error Messages List"},"content":{"rendered":"

table.hovertable {
\nfont-family: verdana,arial,sans-serif;
\nfont-size:11px;
\ncolor:#333333;
\nborder-width: 1px;
\nborder-color: #999999;
\nborder-collapse: collapse;
\n}
\ntable.hovertable th {
\nbackground-color:#c3dde0;
\nborder-width: 1px;
\npadding: 8px;
\nborder-style: solid;
\nborder-color: #a9c6c9;
\n}
\ntable.hovertable tr {
\nbackground-color:#d4e3e5;
\n}
\ntable.hovertable td {
\nborder-width: 1px;
\npadding: 8px;
\nborder-style: solid;
\nborder-color: #a9c6c9;
\n}<\/p>\n

SQL Server error messages can be found in sysmessages table in the master database.
\nFollowing are the columns of sysmessages table.<\/p>\n\n\n\n\n\n\n\n
Column_name<\/th>\nType<\/th>\n<\/tr>\n
error<\/td>\nint<\/td>\n<\/tr>\n
severity<\/td>\ntinyint<\/th>\n<\/tr>\n
dlevel<\/td>\nsmallint<\/th>\n<\/tr>\n
description<\/td>\nnvarchar<\/th>\n<\/tr>\n
msglangid<\/td>\nsmallint<\/th>\n<\/tr>\n<\/table>\n

Following pages that contain list of sql server error messages.<\/p>\n