| Code | Description | 
| 1 - 9 | Informational messages/warnings. | 
| 10 | N/A. @@ERROR won't be set. | 
| 11 - 16 | Regular programming errors. Level 16 is not more serious than 11 | 
| 11 | Specified Database Object Not Found | 
| 12 | Unused | 
| 13 | User Transaction Syntax Error. E.g. deadlock. | 
| 14 | Insufficient Permission | 
| 15 | Syntax Error in SQL Statements | 
| 16 | Miscellaneous User Error | 
| 17 | Run out of a configurable resource, such as locks | 
| 18 | Nonfatal internal software problems | 
| 19 | Nonconfigurable resource limit has been exceeded | 
| 20 | An error with a statement issued by the current process | 
| 21 | SQL Server has encountered a problem that affects all the processes in a database | 
| 22 | A table or index has been damaged | 
| 23 | The integrity of the entire database is affected and the database will be marked suspect | 
| 24 | Hardware problem | 
| 25 | System error | 
Saturday, 12 March 2011
SQL Error Severity and Level Cheat Sheet
Sometimes I have to raise errors manually inside a stored procedure. It will be handy to have an error severity cheat sheet.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment