Home Forums Programming Service Broker end conversation gets blocked by process with request_id 0? RE: end conversation gets blocked by process with request_id 0?

  • I have not found more information why this happened, but after a restart of the sql server the lock that was held already for almost 14 days was released and both symptoms were fixed: the closed conversations are cleaned again and the one conversation that was in 'ER' state could successfully be ended. Problem solved, but no idea what caused it.



    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]


    If you don't have time to do it right, when will you have time to do it over?