May 5, 2009 at 11:34 am
Hey all....Wondering if anyone knows where I can find a list of the various State Codes shown as part of the "Exception" error message in a Trace File. I'm seeing a lot of "Error: 1934, Severity: 16, State: 1"; I am using the sysmessages for the error number, and have used BOL for the severity levels. However, the only thing I can find for State is that it tells the developer where the problem in the code is. Riiiiight. So as someone who's been more or less dropped into a role of Performance Tuner, I'm supposed to know these, but as someone that's new, I have no idea.....I'd appreciate any suggestions, ideas, etc. etc. etc.
Thanks a lot! 😀
Chris
May 5, 2009 at 11:54 am
Having looked at BOL as well, I would actually say, don't worry about the STATE CODE for standard error messages. From what I read, breifly, I'd be more concerned about the error code and severity. The state code may have more significance with user defined error messages.
May 5, 2009 at 11:58 am
Awesome, thanks Lynn! I guess that makes sense if it's a specific error to your application or for more in-depth tuning purposes. Out of my scope of knowledge, so I'll let the developers worry about that!
Take care
Chris
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply