Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Service Broker (2005)  EXECUTE permissions for queue

Author  Topic  wsoranno Starting Member 1 Post Posted - 2010-09-14 : 14:18:06 I am getting the following error in the SQL log: The activated proc [dbo].[ProcessTaskErrors] running on queue W.....R...Update.dbo.TaskErrorMessageQueue output the following: 'The EXECUTE permission was denied on the object 'sp_send_dbmail', database 'msdb', schema 'dbo'.' This is followed by multiple: The activated proc [dbo].[ProcessTaskErrors] running on queue W.....R...Update.dbo.TaskErrorMessageQueue output the following: 'The service queue "TaskErrorMessageQueue" is currently disabled.' The stored procedure ProcessTaskErrors will send an email about the errors. I had to detatch the W.....R...Update database to clear up some log issues in another database. After reattaching, I now get this error. We have been using Service Broker for about 3 years with no major problems. Any insight would be appreciated.