The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
2k views

sql error “Service Broker needs to access the master key in the Database ”xxx" Master Key has to exist

I am pretty new to SQL and administration of databases and still learning. We receive one SQL error for quiete a long time, which has as far as we know no effect on our application. So we put that to ...
2
votes
1answer
266 views

SQL Server Broker Service with Active - Active replication in place

We currently have two datacenters in Active - Active mode and using SQL replication between the two datacenters (with a small delay). I'm developing a new process that will use SQL Server Broker ...
1
vote
1answer
568 views

MSSQL 2008R2 Service Broker Initiator Queue Filled With Old Conversations

My initiator queue is filled with about 18 million old messages of either EndDialog or Error message_type_name. Apparently the Microsoft sample code I used to set up internal activation ...
0
votes
1answer
344 views

What is the correct way to backup, move and restore a database that uses Service Broker?

I'm currently developing an application which uses SqlDependency which relies on the Service Broker. I'm running into an issue every time I move the database from development to staging in that I'm ...
0
votes
2answers
230 views

Configure Remote Service broker

I need help in configuring Service broker in sqlserver 2008. My requirement is to transfer data from one sql web server to another web server. I have followed the all steps like created master key, ...
1
vote
1answer
206 views

How do I enable a disabled Event Notification

I have a scenerio where I am using external notification to process documents being sent in from the entire navy fleet, normally I have no problems, but just a few days ago an administrator changed ...
1
vote
1answer
5k views

How do I enable a service broker queue when it is disabled?

I have a scenario where an external application is monitoring a queue and then taking an action when something is put into the queue. I just wrapped this to happen inside of a transaction to try to ...
0
votes
1answer
63 views

Recover errored message from SQL Server Service Broker

We've been using SSSB 2008 for the past year, and it's been wonderful. (Well, compared to MSMQ anyways.) However, we've only been using same-database queueing, not the routing features. Some changes ...