Retrieve info from service broker queue as soon as they arrive

• Sarsoura

  Ten Centuries

  Points: 1220

  More actions

  May 4, 2010 at 10:17 pm

  #224107

  I have xml messages sent to the service broker queue

  How Can I retrieve those xml messages as soon as they arrive and provide those messages one by one to a stored procedure to be executed for each message

  Thanks in advance

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  May 4, 2010 at 10:32 pm

  #1162216

  Lookup "Internal Activation", I think this is exactly what you are asking for.

  CEWII

• Sarsoura

  Ten Centuries

  Points: 1220

  More actions

  May 5, 2010 at 10:07 am

  #1162596

  Thanks

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  May 5, 2010 at 1:33 pm

  #1162737

  You are welcome.

  CEWII