Cannot see data from SYS.CONVERSATION_ENDPOINTS over a linked server

Hello,

I have a server that is used to query other servers to ensure that things are functioning correctly. On some of our servers we are running ServiceBroker and some of the monitoring involves querying the SYS.CONVERSATION_ENPOINTS view on these servers.

When I query the SYS.CONVERSATION_ENPOINTS view over a linked server it returns zero rows, though when I run the same query locally it returns data. I initially thought it was a permission issue but it seems I can see data across the linked server to other system views within the sys schema (ie sys.all_objects).

Is there something different/special about SYS.CONVERSATION_ENDPOINTS that prevents me from seeing its data across linked servers or have I simply got permission problems.

Thanks

Ian

It probably is a permissions issue. sys.conversation_endpoints permissions are governed by 'RECEIVE' permission on the queue of the service the convresation endpoint belongs to.