Member Avatar for everhett.raman

hi,

M'soft sites documented that

RECEIVE TOP (n) FROM Target

should fetch the n number of message from the specified queue. I am having problem with this, and do not know why because not much resource is available pertaining this. Tried finding for an answer on Klaus Aschenbrenner's book, failed.

i) I created the queue in very straight forward script

CREATE QUEUE Target WITH STATUS=ON

.Did i miss any arguements on the queue creation?

ii) Is there any database properties i need to check?

Thank you guys, I still new to Service Broker, any help will be appreciated.

  • 1 Contributor
  • 2 Replies
  • 122 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by everhett.raman
Member Avatar for everhett.raman

Hi,

Looks like there is no help on this issue. Any comment will be appreciated. TQ.

Member Avatar for everhett.raman

Hi guys,
As the pressure for dateline mounted, i had to design a fast solution using the SSBS. There aren't much resources, or otherwise meaningful unless someone understood the SSBS concept. This seems very specialized area of skill-set. I referred to Klaus Aschenbrenner's book for solution implementation.

As solution already designed, this issue of fetching many message (code as below) became an issue.

RECEIVE TOP (10) message_body FROM Target

Could only fetch single message each time. Therefore posted here for some help. At the same time, i revised the SSBS concept again to analyze the problem. As for my findings:
1. Each conversation_handle was different ( because i instantiated different conversation for each message) in my TargetQueue
2. RECEIVE TOP(n) only returns messages belonging to the same conversation_handle only if specified in TOP clause.

Someone please verify this finding to be true, so that it can help me solving my problem and be a help to other as well.

Thank you.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.