service-broker
Deletion of SQL Service Broker queue is slow
We have a system using SQL server service broker inside a single database. This database is mirrored using high-safety mode and a witness.[详细]
2023-03-25 13:15 分类:问答Access to the remote server is denied because the current security context is not trusted
I ha开发者_运维问答ve a service broker which calls a stores procedure sp_dequeue queue --> ACTIVATION[详细]
2023-03-23 02:56 分类:问答Service broker queue message arrived but notification doesn't work
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:[详细]
2023-03-08 19:32 分类:问答Service Broker error handling simulation
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[详细]
2023-03-08 06:45 分类:问答Minimum user permissions to run a SQL Service Broker Application
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[详细]
2023-03-06 10:04 分类:问答Service Broker, endpoint - do i really need a certificate to send message between two servers?
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?[详细]
2023-02-27 15:29 分类:问答How do you include Service Broker in a VS2010 Database Project
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[详细]
2023-02-19 03:08 分类:问答SQL Service Broker to notify external app
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[详细]
2023-02-17 01:17 分类:问答messaging between clients without polling
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.[详细]
2023-02-16 18:50 分类:问答Sending and Receiving SQL Server Service Broker Messages within Nested Transactions
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[详细]
2023-02-16 18:22 分类:问答