I have a service broker message queue, each message calls a web service via a CLR stored procedure to do some processing
I have a table with a complex trigger that eventually calls the Service Broker to run a stored procedure with a parameter that is a table (custom type).
I have a couple of SQL servers with databases supporting two different applications. I need tocapture changes to similar data from each database, but process it sequentially. Service Broker fits the b
This is my first question! So I hope I provide enough information: We are attempting to send around 1000 emails by taking advantage of the SQL Mail Service Broker. We are relatively new to this, but
I would like to make use of SQL Server notifications to capture insert/update events at my database within a windows service. I am attempting to use the SQLDependency object. The MSDN articles make th
I am researching sql server service broker as a message processing technology for our application. In our scenario, the messages that are sent from one client application (WPF) needs to be queued up
I\'ve used the following code to set up deadlock monitoring: http://weblogs.sqlteam.com/mladenp/archive/2008/07/18/Immediate-deadlock-notifications-without-changing-existing-code.aspx
I\'ve implemented two SSB across two different instances. They are data push pattern based on asynchronous triggers.
We have a production database where service broker was disabled. We have a profiler that logs every backup / restore operation. I cannot find any restore operation in its trace.
We have an app that creates queues and services in SQL Server using the Service Broker to handle db communication. The app uses these services and sends/receives messages correctly, but I now want to
加载中,请稍侯......