Amit Jethva points out a method to catch the errors from a stored procedure and log them into SQL server Error log .. rather than returning them to the front end application ... and believe me this looks like a cool way to capture errors for small applications ...
http://www.sqlservercentral.com/columnists/ajethva/capturingtheerrordescriptioninastoredprocedure.asp
I hope to see him blogging soon ... “Subscribed” in advance ...