BROKER_QUEUE_DISABLED Problems

May 31, 2006

I have created a queue and service all in the same database as follows:

CREATE QUEUE ODS.[Queue Watch];

CREATE SERVICE [Queue Watch Service]

ON QUEUE [Queue Watch];

Next I created an event Notification as:

CREATE EVENT NOTIFICATION [OrderQueueDisabled]

ON QUEUE [ODS].[Order Process Queue]

FOR BROKER_QUEUE_DISABLED

TO SERVICE 'Queue Watch Service', 'current database';

When I get the queue to disable ([ODS].[Order Process Queue] ) by setting the activated stored procedure to do a 'Select 1/0', I don't get a message in the ODS.[Queue Watch] queue. There is nothing returned from any of the following queries:

Select * from sys.transmission_queue

SELECT * FROM sys.server_event_notifications

Select * from [ODS].[Queue Watch]

select * from sys.dm_qn_subscriptions

All of this is running the same database.

.



View 6 Replies


ADVERTISEMENT

BROKER_QUEUE_DISABLED Supported On SQL Express?

Jul 31, 2007



Is this event notification supported on SQL Express or no? I found it surprising that, despite seeing the correct entries in sys.event_notifications, I never received this event notification (BROKER_QUEUE_DISABLED) when the queue became disabled. Its my understanding that the only thing that will cause a queue to disable is 5 consecutive rollbacks, so I was suprised when I didn't get any indication that the queue turned off. The rollbacks would have occurred in a .NET application if that makes a difference, whereas my handling of the event notification was in SQL Express. This worked fine when testing on SQL Developer, by the way.

Thanks!

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved