Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Using SQL Server Service Broker to update multiple clients

 
   Database Forums (Home) -> Notification Services RSS
Next:  acomplia soft sans prescription un Achat de acomp..  
Author Message
austirob

External


Since: Aug 09, 2008
Posts: 1



(Msg. 1) Posted: Sat Aug 09, 2008 6:29 pm
Post subject: Using SQL Server Service Broker to update multiple clients
Archived from groups: microsoft>public>sqlserver>notificationsvcs (more info?)

Hi,

I am trying to implement an excel based solution whereby stock prices in a
spreadsheet are updated (via RTD) every time a trigger in a database places
messages in a queue. Not that it's relevant to my question, but the client
part of the solution is implemented using the C# sqlnotificationrequest
object.

My question relates to what exactly the "WAITFOR (RECEIVE..." syntax does. I
have done an awful lot of reading on this, which says that when this SQL
command is executed the message is taken off the queue, but using
"RETENTION=ON" when setting up the queue means that messages are left on it
once they have been read.

I want to have multiple excel clients updated, so they will all be executing
"WAITFOR (RECEIVE..." in the sqlcommand bound to the sqlnotificationrequest.
Can I do this, or does this mean that the first one will read the message,
will remove it from the queue and the others won't get it?

I ask this question because I have had some problems with some messages not
being received by the clients. I tried to work out what the problem was by
implementing a "WAITFOR (RECEIVE..." in a loop in a stored proc in the db
itself to read off the queue. When I did this, no messages were received by
my excel clients.

I guess what I am really asking, is can I use a sql server service broker
queue to broadcast messages to multiple clients?

Many thanks

Rob

 >> Stay informed about: Using SQL Server Service Broker to update multiple clients 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Service Broker and SQL Server Express - Is it possible to use Service Broker with SQL Server Express? How? What about in a network where the only database server is the Express edition? -- ------------------------------- Joseph I. Ceasar CLS Computer Solutions

Service Broker question - 1. is this the best place to ask a service broker question? Forgive me Service Broker experts I am speaking outside of my realm here. Is it possible that a component “type” could automatically creates a “conversation” in the Service Broker and....

Notification Service Exists in a Different Server - Hi, I am using notification services for SQL Server 2000 My notification service instance and database exist in one machine whereas I am developing a windows based client for subscription which may exist in other machines. What format do I use to..

SQL 2000 & Service Pack 4 - I have a notification setup on my SQL 2000 server that has worked for 2 years.... Last week, one of my recipient's did not receive their email notification. I had added a new person to the list, so we removed that person. This week a different recipien...

notification service access - I am basically new to sql server 2000 within the last 6 months. At my small company, I was told that they want me to sent out alerts for reasons like a database has reached 80% of its maximum capacity. I am suppose to setup backup and restore..
   Database Forums (Home) -> Notification Services All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]