Table for SQL Errors

• sarang.deshmukh-861026

  Valued Member

  Points: 50

  More actions

  November 7, 2008 at 4:22 am

  #103620

  This may be basic question, but I want to know it.

  What is the name of SQL system table in which error numbers and error descriptions are stored.

• Dwayne Dibley

  SSCrazy

  Points: 2350

  More actions

  November 7, 2008 at 4:31 am

  #895406

  select * FROM sys.messages in sql 2005

• Kishore.P

  SSCrazy Eights

  Points: 8147

  More actions

  November 7, 2008 at 4:42 am

  #895412

  for SQL 2000: select * from master..sysmessages;

  SQL 2005: select * from master.sys.messages;

  This table exists in master database.

• sarang.deshmukh-861026

  Valued Member

  Points: 50

  More actions

  November 7, 2008 at 5:01 am

  #895421

  Hi rjohal, Kishore.P

  thanks a lot, got it.