As you mention, the test from sysmessages isn't that helpful.

Try this interesting technique,

http://www.sqlservercentral.com/columnists/ajethva/capturingtheerrordescriptioninastoredprocedure.asp