I would like to use Service Broker to notify several C# Clients with a change notification that they need to make a call to the database when something is updated by inserting a single message into a message queue and have all the clients receive it.
We are using SQL 2008 and it appears that all conversations between a client and SQL are one-to-one and cannot be many-to-one. I have seen examples where each client must call into the database to setup the communication channel but that seems to be
overkill for what I need.
Of course all clients should be able to read the message and then it would be removed from the queue after all registered clients have accessed the queue. Thanks,
Microsoft Online Community Support
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.