service-broker
SQL Service Broker Peek on queue
I\'m writing a C# application that uses SSB queues to communicate with other systems. When receiving a message from a SSB queue, I am not always sure I am able to handle it. Therefore I would like to[详细]
2023-01-02 00:22 分类:问答Service Broker not working after database restore
Have a working Service Broker set up on a server, we\'re in the process of moving to a new server but I can\'t seem to get Service Broker set up on the new box.[详细]
2023-01-01 23:27 分类:问答What is Service Broker in SQL Server?
What is Service Broke开发者_运维百科r in SQL Server and is it meaningful to enable it in a simple database, not in a distributed database?SQL Service Broker is an extension mechanism that allows you t[详细]
2022-12-31 16:39 分类:问答Monolog conversations in SQL Service Broker 2008
I have a scenario in which I need to process(in SQL Server) messages being delivered as .xml files in a folder in real time.[详细]
2022-12-30 12:10 分类:问答Service Broker is not starting
ALTER DATABASE [Database Name] SE开发者_运维技巧T ENABLE_BROKER; Does not respond, and works infinitely. SQL Agent service is running, what is chances?[详细]
2022-12-30 07:04 分类:问答How do I get the size of a Service Broker Queue quickly when the table is >500k rows?
I\'m trying to determine the total size of a Service Broker Queue and transmission queue when the queue is very large.The problem is traditional querys like the ones below don\'t work since it\'s not[详细]
2022-12-29 16:38 分类:问答SQL Server Service Broker Service Disappearing (Automatically Deleted)?
I\'ve implemented a messaging system over SQL Server Service Broker.It is working great, with the sole exception that every once in a while (maybe once per week per server) my initiator service just v[详细]
2022-12-26 06:09 分类:问答Help with Service Broker error message
I am getting this error in my sys.transmission_queue table whenever I attempt to s开发者_如何学Goend a SQL Service Broker message between two different SQL Server servers. (i.e. the databases are on t[详细]
2022-12-25 21:23 分类:问答Service broker with SqlNotificationRequest
I am in the process of evaluating a Service Broker with SQL noticiation for my project. My requirements is User places a order from System A and it will update Order Table. As soon as order is place i[详细]
2022-12-25 03:00 分类:问答Get hostname when reading Service Broker Queue (SQL Server 2005)
I am trying to configure auditing on my SQL Server using Service Broker. I did all the configuration needed to capture the DDL Events (queue, routes, endpoints, event notification). It is working prop[详细]
2022-12-23 00:17 分类:问答