Error Handling in Service Broker procedures

October 31st, 2007

Error handling in T-SQL traditionally has been a sort of misterious voo-doo for most developers, with it’s mixture of error severities, SET settings like XACT_ABORT, ARITHABORT or ARITHIGNORE and the options to handle the error on the server or at the client. For a long time now the best resource I know on this subject was, and perhaps still is, Erland Sommarskog set of articles at http://www.sommarskog.se/error-handling-I.html and http://www.sommarskog.se/error-handling-II.html. But the introduction of Service Broker activated procedures adds some new issues to consider when designing your application and this post is about what these issues are these and how to best cope with them. 

Read the rest of this entry »

Welcome to rusanu.com

October 29th, 2007

Welcome to my new blog: http://rusanu.com/blog. Here I will continue to post articles on Service Broker as I used to on the old MSDN blog, as well as other areas of interest. Fell free to leave a comment and feedback is not only welcomed, but much desired! Hope to see you soon back and I hope to have some great articles ready soon.