eyespi20 (2/18/2013)

---

We moved our production databases from an SQL2008R2 Standard Edition to SQL2012 Enterprise edition this past weekend. I have a DBMailUserRole defined in MSDB that has the execute rights to the sp_send_dbmail stored procedure and the user that is attempting to execute the sp is a member of the role, but I'm still getting this error.

Anyone have any idea what I need to do in order to get this working?

Thanks!

eyespi20 (2/18/2013)

---

We moved our production databases from an SQL2008R2 Standard Edition to SQL2012 Enterprise edition this past weekend. I have a DBMailUserRole defined in MSDB that has the execute rights to the sp_send_dbmail stored procedure and the user that is attempting to execute the sp is a member of the role, but I'm still getting this error.

Anyone have any idea what I need to do in order to get this working?

Thanks!

SELECT * FROM msdb.dbo.sysmail_sentitems order by sent_date desc

SELECT * FROM msdb.dbo.sysmail_allitems order by sent_date desc

SELECT * FROM msdb.dbo.sysmail_event_log order by log_date desc
SELECT * FROM msdb.dbo.sysmail_unsentitems 
select * from msdb.dbo.sysmail_configuration