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
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.
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
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.
ALTER DATABASE [Database Name] SE开发者_运维技巧T ENABLE_BROKER; Does not respond, and works infinitely. SQL Agent service is running, what is chances?
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
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
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
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
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
加载中,请稍侯......