| Thread | Last Post | Replies |
|
| Confusion about Conversation Groups | 30 Jan 2006 14:19 GMT | 2 |
In BOL, it says that SQL Server uses Conversation Groups to provide exactly-once-in-order access to messages, but how can this be if each dialog has its own sequence numbers? Two dialogs in the same conversation group could both have the same or overlapping sequence numbers or ...
|
| Priority Queues | 30 Jan 2006 14:13 GMT | 2 |
I would like to use SSB to create priority queues so that I can process some messages before other messages. I am currently thinking that I am going to have to pre-create a number of dialogs between the the intiator and the receiver, and create conversation groups for each ...
|
| Using service broker to send table updates to another DB | 12 Jan 2006 00:58 GMT | 3 |
We are trying to determine how to alleviate performance bottlenecks on our OLTP database. Since about 80% of our queries are "reporting" type queries, we are going to push OLTP data to a new "reporting-friendly" type of database.
|
| Answers | 11 Jan 2006 21:23 GMT | 1 |
|
| Send message from service in one DB to service in another DB | 06 Jan 2006 03:32 GMT | 2 |
I have two databases DB1 and DB2. Bothe the databases are on the same SQL instance. Both have Service Broker enabled. I am trying to send message from DB1 to DB2 using the following code. On DB1, I did the following:
|
| Message in Transmission Queue | 03 Jan 2006 06:02 GMT | 6 |
Environment: SQL 2005 9.0 RTM and Visual Studio 2005. Both are installed on the same machine. I am sending a message from a C# application to a Service Broker Queue. It ends up in transamission queue with the following message in
|