• Thanks ALZDBA for ur quick reply.

    When I executed the query on initiator instance I was getting is_broker_enabled = 0 so I executed the below query now I got the below given output.

    ALTER DATABASE msdb SET ENABLE_BROKER

    Q_005 name is_broker_enabled service_broker_guid

    msdb 1 6531971A-433F-

    Now I am not getting that error "broker is disabled in msdb"

    Now when I run the SP to start dialog on initiator again the messages are getting stuck in transmission_queue same thing is happening even when I initiate the dialog from other instance ietarget as initiator and initiator as target then also messages are getting stuck in transmission_queue on the other instance.

    when I checked the transmission_queue I am getting the below o/p

    to_broker_instance is empty, is_conversation_error=0,

    transmission_status is empty

    What to do now please help me out in resolving this issue.

    Thanks.