|
wsoranno
Starting Member
1 Posts |
 Posted - 09/14/2010 : 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. |
|
EXECUTE permissions for queue
