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.
In SQL Server 2005 and later, the visibility of metadata is limited to securables that a user either owns or on which the user has been granted some permission.
I would suggest you take a look at the following article:
Metadata Visibility Configuration:
If you have any feedback on our support, please click
TechNet Community Support
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?