As you mention, the test from sysmessages isn't that helpful.
Try this interesting technique,
http://qa.sqlservercentral.com/columnists/ajethva/capturingtheerrordescriptioninastoredprocedure.asp
--------------------
Colt 45 - the original point and click interface