Will do. Thanks again.

You are awesome. That resolved it. I decided to update just the profile name and it resolved all the issues. 🙂

Thank you!

Or how do I just completely stop the error without having it notify us anymore. That is fine also.

I created an account called SQLAlerts. That account is mapped to MSDB with a role of DatabaseMailUserRole.

I am unsure if that is still the name of the profile because...

I was able to remove (drop) the trigger which stops them, but it doesn't fix that error above.

Yes we are getting emails.

But it's not related to database mail, but more related to this procedure which I am trying to remove.

http://www.mssqltips.com/sqlservertip/2864/email-alerts-when-new-databases-are-created-in-sql-server/

Anyone?

Basically, how do I remove the msdb.dbo.sp_send_dbmail that was put in there to create a new one or not use it?