service-broker_开发者

Service Broker messaging which calls Web Service not ending

I have a service broker message queue, each message calls a web service via a CLR stored procedure to do some processing[详细]

2023-04-12 11:16 分类：问答

How can I debug a stored procedure running from a Service Broker queue in SQL Server 2008?

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).[详细]

2023-04-12 07:06 分类：问答

Sending messages from multiple servers to one Service Broker Queue

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[详细]

2023-04-07 01:00 分类：问答

Timeout Error - Sending mail through SQL Mail - Service Broker Queue

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[详细]

2023-04-05 18:08 分类：问答

SQL Server Notifications - My OnChange does not fire from a windows service

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[详细]

2023-04-02 13:44 分类：问答

SQL Server Service Broker - Message Timeout

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[详细]

2023-03-31 15:03 分类：问答

msdb.dbo.sp_send_dbmail does not execute within a stored procedure

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[详细]

2023-03-30 00:32 分类：问答

SQL Server Broker Service Target Transmission Queue issue

I\'ve implemented two SSB across two different instances. They are data push pattern based on asynchronous triggers.[详细]

2023-03-27 15:10 分类：问答

Are there other reasons for service broker to be disabled than a RESTORE DATABASE

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.[详细]

2023-03-26 12:22 分类：问答

How to quickly shut down all elements of Microsoft SQL Server Service Broker?

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[详细]

2023-03-25 20:34 分类：问答