I think you need to move the ROLLBACK to before the mail send and raiserror, this will ensure that the ALTER DATABASE statement is rolled back but then allow the mail to be sent.
Follow me on twitter @EvoDBACheck out my blog Natural Selection DBA[/url]