Select from SSB.SendQ from another server by using linked server


  • Hi, I'm trying to run: select conversation_handle from [Linked_Server].SSB.sendQ

    The error message I get is:  Invalid object name '[Linked_Server].SSB.sendQ'.

    When I open the expand the linked server in my console, I only see 'Catalogs' and 'SSB'. But under SSB I only see 'Tables' and 'Views', and I do not see 'Service Broker' and the queues.

    What I want to do, is it something that can be achieved by editing the properties of the linked server? Or it needs to be configured from the SSB itself, and how?



    Thursday, December 19, 2013 3:18 PM