I need to send an email from trigger that also performs rollback. But email is not sent
exec msdb..sp_send_dbmail .....
Without rollback, the same statement sends it successfully and I receive the email. With rollback, there's message saying that it's queued, but I don't receive anything.