I am completely new to Service Broker. I got introduced to it indirectly when learning SQL Server Cache Dependency for ASP.NET data caching. When running a code sample a Service and Queue were created on development database. I am done with this sample but I still see recurring "BEGIN CONVERSATION..." and "WAITFOR(RECEIVE TOP (1)..." queries (every minute or so) for this database in SQL Server profile. Such queries do not appear for any other database.
After taking a closer look I found there is a queue and a service under "Service Broker" for this database. I deleted them both but the queries didn't stop and after checking again I see that they somehow got re-created "automagically".
Hot to get rid of them completely?
Do you mean the objects under "Queues => System Queues" / "Services => System Services"? That are System objects, which can't be deleted.
But the queries are running from a Client app / Queue activator, so check which Client(s) sends the requests.
Olaf Helper[ Blog] [ Xing] [ MVP]
No, I mean under SomeDatabase\Service Broker\Queues and SomeDatabase\Service Broker\Services.