question

jagannath avatar image
jagannath asked

sql query notification

Hi All, I have a .net socket service windows application. I am running 6 instance of the application. i am using sqldependency call to get notification from sql server. my notification query is like below for each instance of application

select status from q_request where status=2 and terminalcode=18
select status from q_request where status=2 and terminalcode=19
select status from q_request where status=2 and terminalcode=20
select status from q_request where status=2 and terminalcode=21
select status from q_request where status=2 and terminalcode=22
select status from q_request where status=2 and terminalcode=23
there are six clinet application reading message from respective socket service. but my problem is that when one socket service is sending message to its respective client other socket service can not able to send message to its respective client. i want to run all six socket instance communicate with thier client application .
sql-server-2008querynotification
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
@jagannath - Sorry you have not had a reply yet. I think that your question may be more quickly answered on a site more focussed on .Net than SQL Server. We are all, in the main, DBAs here and the .Net element of your question is outside our experience. We do have developers who visit this site but they may not be here as regularly as you might need for you solution. Please do come back if you have a SQL Server question and I am sure we will be able to give you sueful information
1 Like 1 ·
jagannath avatar image jagannath commented ·
Hi all, Is there any confusion on my question? Please give me some answer. I need to solve this problem.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.