none
viewing closed conversations RRS feed

  • Question

  • Wierd problem here

    As one user, when i select * from sys.conversation_endpoints I can see all (I assume) conversations in all states specifically DO, DI and CD

    However when I change to another user I see only DI

    Why is this?

    If it is a permissions issue what permission do I have to grant to a user to see all conversations in sys.conversation.endpoints?

    Thursday, January 5, 2006 3:15 PM

Answers

  • An user can see only conversations that are bound to services hosted on queues on which it has RECEIVE permission.

    Note that certain states are for 'system use only', so to speak, and loose the information about which queue they are bound to. Conversations in these states can only be seen by dbo.

    HTH
    ~ Remus

    Thursday, January 5, 2006 7:05 PM
    Moderator