sending message between databases in different servers using service broker

  • Hi All,

    I'm trying to send message between two databases in different servers using service broker

    When I send message the I could see the output as 'Command(s) completed successfully' But I could not see that message in Queues...What might be the reason?

    Thanks in advance!!

  • One of the regular posters on here did a presentation on a series of things that might be possible issues for that. His name is RbarryYoung.

    His presentation is located here:

    http://www.movingsql.com/dnn/LinkClick.aspx?fileticket=c7EJbXre%2fLg%3d&tabid=125&mid=461

    Or - simply visit his blog and pick upthe link there:

    http://www.movingsql.com/[/url]

    That should get you started. I'm sure he will be by later....

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • Hey, thanks for the plug, Matt!

    The presentation is called "The Top 10 Reasons You Aren't Already Using Service Broker", and there are code examples accompanying it. Matt's links are right on.

    You probably want to start with "Dude, Where's My Error?", which I think is #4.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply