none
How to clear messages in a queue which has retention = ON without ending conversation

    Question

  • I'm using Event Notification in SQL Server 2008 R2.    I'm trying to clear messages in a queue which has retention = ON without ending conversation.  

    For testing purpose, I have tried to clear messages in the queue using end conversation but that will delete the event notification.


    • Edited by PCSQL66 Tuesday, July 01, 2014 10:19 PM
    Tuesday, July 01, 2014 10:16 PM

Answers