none
Access Service Broker Views

    Question

  • Hello,

    Going through the various views in to the world of Service Broker, I appear to be able to view records in all of them except sys.transmission_queue. If I run the following query:

    select * from sys.transmission_queue

    I get no rows returned.

    If I run a stored procedure which executes as dbo I see the messages that are stuck.

    What permission am I missing? This is a production environment and therefore I cannot have db_owner etc, only db_datareader.

    I have looked for permissions on sys.transmission_queue and am unable to find this anywhere. I have also looked for some GRANT message for my login but am also failing to find anything here.

    Thanks,


    .Net Developer

    Monday, April 07, 2014 3:25 PM

Answers