That solved my problem! 🙂

Thanks a lot Mike and the others for helping me.

Regards,

Adrian

michael vessey (5/18/2012)

---

also try looking to see how many conversations are still open

select * from sys.conversation_endpoints

maybe your application is not closing the conversations after the messages.

since you've got nothing on...

go to your database, expand the service broker section and look for queues - then its a case of SELECT * FROM queuename - or right click on the queue...

The ERRORLOG contains these:

2012-05-18 00:51:48.81 spid18s ...

michael vessey (5/17/2012)

---

apologies - i didn't read your post correctly 🙁

how about...

Yes, actually we are using Service Broker for our application.

Is it the one causing the problem? We have been using Service Broker for years but never experiencing this problem.

I tried...

Thanks mate! 🙂

Hmm.. not really. Actually I'm looking for the capability so that when 2 or more results came in simultaneously, they will not be matched to a single request (with some...

🙂 Thanks for trying... I know I'm bad in explaining

The remote process is 3rd party, and I don't have any control over it.

I can only send mobile_phone to them, and...

OK. You got the tables correct. The request table is initially like what you've shown.

Now, what will happen is:

1). I got a multi-thread application which will select each entry from...

Yes, but note that ID for table request and table result is unrelated.

Plus, we cannot use the ID for matching because the remote process (done via HTTP) is asynchronous