I use raiserror in nested stored procedures. How do I get the message (format string) from the nested stored procedure and append it to the calling stored procedure raise error. Something similar to: exec sp1 if @@error... @msg = get the raise error from sp1 and add it to this error message raiserror 25000 @msg