Adam,
What a good question!
I got it right, but I wonder: the message is Level 16. BOL says in "Database Engine Error Severities" that the correct answer happens with severity 19 and higher. Does not mean that it could not happen with 16, but it would be nice if BOL explains possible outcomes of Levels 11 to 16.
While I can not vouch for the complete voracity veracity of the information provided at: http://www.sommarskog.se/error-handling-I.html I found the article very informative and useful. I stumbled accross it while looking for verification for my answer to the question. I had the right answer but it was nice to see "why" my answer was right.
James.
Adam: Guess I should have used the word "accuracy" (either that or learn how to spell! [veracity]). I'm far from and expert in this area and didn't want to steer anyone wrong. I was impressed with the level of detail Erland included and was pretty confident it was accurate, but that was the first time I every looked into what type of error resulted in what type of action. Very good information to know, I think I have made poor assumptions in some of my past projets
