sp_send_dbmail "Mail Queued." Message

I have an After Update Trigger specified on a database table to notify specific users via email when certain customer values are modified. (This is a HACK / Workaround for functionality that doesn't exsist in the product.)

I had be usingxp_sendmail without a problem. I recently upgraded the database server to SQL2005 and wanted to trysp_send_dbmail. (I was interested in the asynch and the non-MAPI nature of Database Mail.)

This is the new code:

EXEC @retval= msdb.dbo.sp_send_dbmail

@recipients= @rec,

@blind_copy_recipients= @bcc,

@subject='Important Customer Information Change',

@body= @body

This is the old code:

EXEC @retval= master.dbo.xp_sendmail

@recipients= @rec,

@blind_copy_recipients= @bcc,

@subject='Important Customer Information Change',

@message= @body

The problem now is that the application reports an update failure because thesp_send_dbmailreturn the message"Mail Queued."

I don't know if there's a way to suppress this message or not. Or some other way to indicate that "all is well" even though the stored procedure returned a message.

Thanks in advance.

[2857 byte] By [DerrickPowell] at [2008-1-10]