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.