Tagged Questions
0
votes
1answer
92 views
Query notifications and connection options
I'm investigating a problem with query notifications. The platform is SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Standard Edition.
.NET errors show a problem reported from SqlNotificationInfo ...
0
votes
0answers
43 views
Service Broker application won't send message between queues [closed]
I made this Service Broker application: http://pastebin.com/M1jZg2Pt
I want to run stored procedure spInsertLogLine and for a record to end up in table log_line.
I do
exec ...
4
votes
1answer
89 views
Large Transaction Log Backups in Service Broker-enabled system
We have a system that uses Service Broker for asynchronous messaging, with a fairly high throughput of messages. We don't really care about the persistent features of SSB in this scenario -- the ...
0
votes
1answer
47 views
UTC date in DMV dm_broker_queue_monitors
It seems that the DMV dm_broker_queue_monitors returns UTC time rather than local time. Why is it so?
I am wondering how to get local time from this view? I can get current time offset, but that is ...
2
votes
1answer
194 views
Using Service Broker internal to a single SQL Express instance?
I understand that SQL Express cannot send Service Broker messages to other instances without a Standard (or better) instance involved in the chain. But is it possible to use Service Broker to send ...
5
votes
0answers
322 views
Service Broker: Queue Monitor is dropped after poison message
I have searched everywhere and there isn't an answer online. There is one similar question on stackoverflow but it's not exactly the same and it has no accepted answer.
When I setup event ...
0
votes
0answers
114 views
In SSB, how would you implement external activation to a particular (1) user when you only have one initiator queue and one target queue?
On a database which has multiple user application instances en-queuing messages to one initiator queue sending messages to a target queue which activates a server application, I am revising the ...
1
vote
2answers
411 views
How to make a flexible service broker receive in a stored sql procedure, how to pass “FROM” parameter into receive
a while ago I asked a question about how to make begin dialog and send more flexible so that it can be embedded in a procedure that takes the to, from, parameters as sysname variables.
Service Broker ...
2
votes
1answer
166 views
Any problem with same conversation handle used by multiple services communicating with one target queue in a multiplexed service broker order queue?
I asked a question about implementing conversation groups in a SQL Service Broker setup which has several User Services communicating with the Server Service (Processing xml data requests to be sent ...
3
votes
1answer
173 views
Service Broker Procedure that will be used by multiple initiators to begin dialog conversation.. how to pass a parameter into it
The standard format for beginning a dialog is like this:
Declare @dialog_handle UNIQUEIDENTIFIER
BEGIN DIALOG CONVERSATION @dialog_handle
FROM SERVICE initiator_1
TO SERVICE 'target_1'
ON ...
1
vote
1answer
170 views
Can we use SQL Express to send messages to SQL Standard using the Service Broker?
We want to use SQL Express at our local sites but to still be able to push data back to our head office using the Service Broker. SQL Server at the head office is 2008 R2 Standard.
Looking at the ...
1
vote
4answers
552 views
The broker in the sender's database is in single user mode
Could you please help with why am I getting this sys.transmission_queue.transmission_status message after restoring from a snapshot?
The broker in the sender's database is in single user mode. ...
