Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jtwork
Yak Posting Veteran
82 Posts |
 Posted - 2008-08-26 : 05:05:18
|
| Hi all,Does anyone have any information on how to correctly read the statement below? Im guessin that the information for msg, state and line mean something?Msg 8115, Level 16, State 8, Line 53 |
|
|
sunil
Constraint Violating Yak Guru
282 Posts |
Posted - 2008-08-26 : 05:13:08
|
| http://www.developer.com/db/article.php/724711 |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2008-08-26 : 05:17:16
|
| Well breaking it down. (assuming this is returned by a RAISERROR statement or similar)Line : Self explanatory - the line number of the batch of sql running (note this can be the line number of a piece of dynamic sql so doesn't necessarily correspond to what you expect)State : An arbitrary level of code. (probably a logical level defined in the code) Meaningless without access to the codeLevel : 16 Error level (1 - 10 are info) 11 - 16 are user errors, 17 are resource errors of some kind, 20+ are fatal errors (16 is classed as – Miscellaneous User Error) See http://www.sommarskog.se/error-handling-I.html#severitylevelsMSG : A user defined mesg returned by your code / server.. This is probably the return code of some stored proc or similar.Without access to the code it's impossible for us to say more. (Unless I'm wrong?)-------------Charlie |
|
|
|
|
|
|
QA Query