Yes, good point.

Take the two pronged approach and use a RAISERROR inside the stored proc too. This way you get messages as they happen but also an easily searchable set if things don't go wrong.

And again, if you have the RAISERROR inside it's own stored proc, you only have to write it once.