 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Service Broker / November 2007Problem with Service Broker Queue
On a SQL Server 2005 (SP1) the following error is occurring. The activated proc [dbo].[sp_sysmail_activate] running on queue msdb.dbo.ExternalMailQueue output the following: 'The service queue "ExternalMailQueue" is currently disabled.'The activated proc [dbo]. [sp_sysmail_activate] running on queue msdb.dbo.ExternalMailQueue output the following: 'The service queue "ExternalMailQueue" is currently disabled.' How can I find out why this queue is disabled? How do you restart a queue? Try: alter queue ExternalMailQueue with status = on Not sure if you'd be able to find out how it got turned off. However, in future, you could create a DDL trigger to trap when it occurs: http://msdn2.microsoft.com/en-us/library/ms189871.aspx  SignatureTom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau On a SQL Server 2005 (SP1) the following error is occurring. The activated proc [dbo].[sp_sysmail_activate] running on queue msdb.dbo.ExternalMailQueue output the following: 'The service queue "ExternalMailQueue" is currently disabled.'The activated proc [dbo]. [sp_sysmail_activate] running on queue msdb.dbo.ExternalMailQueue output the following: 'The service queue "ExternalMailQueue" is currently disabled.' How can I find out why this queue is disabled? How do you restart a queue? Your queue is likely being disabled because it causes five RECEIVEs to be rolled back and trigger the poison message protection, that disables the queue. To understand why it is being disabled, best way is to manually run the procedure (using EXEC) and watch out for error messages it produces. > On a SQL Server 2005 (SP1) the following error is occurring. > [quoted text clipped - 8 lines] > > How do you restart a queue? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.