BROKER_QUEUE_DISABLED Problems
May 31, 2006I 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.
.