[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3553
  • Last Modified:

List of SQL Error Codes/Messages

Where can I find an entire list of the trappable SQL error codes?  I don't have easy access to the Books Online (the errors are listed in Books Online).  I need to traverse through the list to find all error numbers that pertain to record locking so that I can allow the program to retry to edit/update a record.  Is there a web site, Access database or text file that contains a list of the error codes.
0
mnord
Asked:
mnord
  • 2
  • 2
1 Solution
 
Gustavo Perez BuenrostroCommented:
0
 
mnordAuthor Commented:
I did a few searches but did not find a list of error codes.
0
 
Gustavo Perez BuenrostroCommented:
Books online are available at:

http://support.microsoft.com/support/default.asp?PR=sql&RLD=183

go to:
*Reference Books
 SQL Server 7.0 Books Online
0
 
mnordAuthor Commented:
Re-read my previous my question.  Accessing Books Online is not an option.
0
 
formulaCommented:
In master DB, select * from sysmessages.  This will give you of the predefined sql errors and warnings.  You can also create your own with RAISEERROR command.   Hope this is what you want.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now