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

    Question

  • 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?

    Thanks,

    Dario

    Thursday, December 19, 2013 3:18 PM