We have a system using SQL server service broker inside a single database. This database is mirrored using high-safety mode and a witness.
I ha开发者_运维问答ve a service broker which calls a stores procedure sp_dequeue queue --> ACTIVATION
I am using the External Activator provided by Microsoft to monitor service broker queue messages. The main queue\'s name is \"ReportQueueTarget\". I also set up a notification queue like this:
I work now in project in which multiple POSes should be synchronized to main server by using Server Broker feature. Now i prepare error handling for this solution and want to show to client how it wor
I would like to use SQL Server 2005 Service Broker to create an update application. The main reason I\'m looking to use Service Broker is that I need to call a web service from a trigger (which I\'ve
Do I really need to create a certificate to send a queued message between sql servers? Can I use dbo authentication for the endpoint on both servers?
I\'m trying to add my Service Broker queues to my database project and I\'m not entirely clear on what is the best way to do t开发者_Go百科his. There are two views available to me, Solution Explorer a
After much searching on Service Broker, I came across this question and answer: My scenario is similar to the one mentioned there, in that I have a SQL trigger on a table, and in this trigger I\'m ca
I have a network of MS SQL servers connected to each other with (C++/C#)clients connected to them. and I\'m about designing a way of messaging between clients and server-client messaging.
I\'d like to use SQL Server 2008 Service Broker to log the progress of a long-running (up to about 30 minu开发者_如何学运维tes) transaction that is dynamically created by a stored procedure. I have tw
加载中,请稍侯......