I know this is a pertty aged thread, but still helps a lot to me.

One issue i running into is, how to clean up history data in Logging table on daily/hour basis? Our environment has heavy activities, 10,0000 rows inserted int Logging table per hour.

I was wandering to restart Service Broker's conversation and truncate log table, just fail to manage the conversation on the right way.

Could someone kindly shed some lights on this? I'm a idiot on Service Broker:(

Thanks so much!