Error: The service queue "ClientQueue" is currently disabled.

Well I downloaded an example (HelloWorld) from www.SQLServiceBroker.com yesterday and it WAS working this morning, however; now I'm getting this error:

The service queue "ClientQueue" is currently disabled.

Which I found from looking at the Service Broker Statistics Report is true. There are 5 queues total and only the dbo.ClientQueue is disabled.

Questions:

1). How do I enable it?

2).What caused it to become disabled?

I tried running the following commands:

1). alter database [dbo].[ServiceQueue] set enable_broker

2). alter database [ServiceQueue] set enable_broker

within the Microsoft SQL Server Management Studio.

Thanks

God Bless...

doug

1) ALTER QUEUE [ClientQueue] WITH STATUS = ON
See http://msdn2.microsoft.com/en-us/library/ms189529.aspx

2) Most likely you rolled back 5 RECEIVEs in a row, activating poison message detection.
See http://msdn2.microsoft.com/en-us/library/ms166137(en-US,SQL.90).aspx

HTH,
~ Remus|||Thanks!

That Worked!

Doug