service-broker's questions - English 1answer

132 service-broker questions.

I have been trying in many way, from sys.conversation_endpoints to find out which route and which endpoint my service broker session is using. SELECT conversation_handle, is_initiator, s.name as '...

from CREATE QUEUE (Transact-SQL): RETENTION Specifies the retention setting for the queue. If RETENTION = ON, all messages sent or received on conversations that use this queue are retained in ...

I have service broker running on different servers. Just recently I had to rebuild one of the test servers and it had a complete service broker solution running there. For the next time I need to ...

I'm using SQL Server Management Studio to generate scripts for all the objects in an existing database: but the objects related to SQL Broker (messages, queues and services) are not generated. I've ...

SQLDependency Notifications work fine logged in as Windows Domain User, using Trusted Connection. But not as SQL-User: I created a db login, user and role as follows: CREATE LOGIN myLogin WITH ...

I make an extensive use of SQL Server Service Broker to trigger/parallelize data science tasks (data imports with SSIS or direct queries to another database on the same server, then data management ...

I have a database where I have a ServiceBroker up and running. For unknown reasons we have experienced a lot of problems with missing conversation handlers; I.e. The conversation handle "D33EC01C-...

Let me acknowledge, I don't know much about database efficiency neither Service Broker as a whole, where I work the dba that used tp handle these kind of things left some weeks ago. The company uses ...

After we tried configure a database with service broker into an always on environment and failed (the service broker is not working properly) we are now considering to try mirroring for high ...

I receive this error message in SQL Server error log every 15 minutes. I have setup AOAG on this server. The database option "Service Broker - Broker Enabled" is turned on for the Blackberry related ...

On a test box I need to give a user the ability to enable a queue if it becomes disabled. I gave the user Control on the queue, but they keep getting this error: Cannot find the user 'owner' ...

SQL Server has Service Broker, which provides messaging and queueing functions between instances. I am new to using this technology and want to know which kind of messages does it send between ...

one of my clients has a database that works with service broker, last week we tried to move the database to an always on environment without knowing the application uses the service broker. after ...

We have two queues, SSBInitiator and SSBTarget. In my example situation, I have ran the following code to create a conversation: BEGIN DIALOG CONVERSATION @ConversationHandle FROM ...

I am facing the following challenge. I want to have a central MySql server having all the data and several satellites servers that hold part of the data. Satellites servers will hold some original ...

I have the following procedure USE ServiceBrokerTest; GO CREATE PROCEDURE PublishNotification @NotificationData VARCHAR(1000) AS DECLARE @InitDlgHandle UNIQUEIDENTIFIER BEGIN ...

I have a broker implementation that reuses dialogs (based on Remus's blog post). Recently a DBA issued a SET NEW_BROKER on the target server, which changes the Broker GUID on that host. The routes on ...

Due to lack of my knowledge in service broker i am finding hard time in troubleshooting Service broker in one of the databases. Initially the Service broker somehow got disabled on this database ...

I was debugging and stuck a bunch of log statements into my activation procedure including a statement that logs the value of @@ROWCOUNT that is used in this manner: INSERT INTO ###Debug(SomeMessage, ...

I have a mirrored database that was using a service broker to push notifications to a client. The broker creation framework started making duplicates and this caused serious problems so i rolled back ...

I have two tables (TableA, TableB) and each table have attached a trigger (TriggerTableA, TriggerTableB) that calls a stored procedure SendMsg. The triggers are associated to insert and update ...

I'm trying to enable Service Broker on a SQL Server 2012 database that is part of an availability group and keep getting this error message: The operation cannot be performed on database "dbname" ...

Our developers are currently working on Service Broker and will be implementing in production soon. What do I need to worry about with Log Shipping in regards to DR? The environment they are ...

We migrated all our databases from an older SQL server to a newer one. Some of these databases are using the service broker. Every time we restart the database server, the contracts, queue, message ...

My organization has been successfully using service broker, dialog security, for a few years. I have a new instance of service broker that I would like to configure, but I believe I am running into ...

We are considering RabbitMQ for queuing several thousand tasks per minute and then processing them from 300+ virtual machines. We have a smart scheduling web API that will intelligently (fairly) ...

We use Service Broker heavily for asynchronous background processing. Additionally we want to use it for extended event processing. Is it possible to use Service Broker listener as target for an ...

I've got this sequence of error messages showing up regularly in my server error log: Error: 9245, Severity: 16, State: 1. During the last time interval 257 query notification errors were ...

I have a situation where multiple client apps send messages via the Service Broker (utilizing stored procs). These messages are picked up by yet another client app and then processed. The way the ...

I hope someone can explain some behavior I've got within the Service Broker, which is the first time I've used it so it's probably my lack of understanding. I've got a complex set of stored ...

I'm trying to set up a test environment for Service Broker communication between 2 SQL Server 2016 SP1 instances. I've created db master keys, certificates and endpoints in the master db for each ...

I am facing a really confusing problem with our SQL Server, and I hope somebody can give me hint how to debug this issue. Grab a cup of coffee or something, this is going to get slightly convoluted. ...

I restored a database from SQL Server 2014 Enterprise to SQL Server 2017 Standard. The restore went through fine without any issues/errors. I then run DBCC CHECKDB on the database and I get the ...

We are trying to get Service Broker working in our environment in order to solve a business case. I don't know if the message title is a good one, but my question is below. But it may not be a good ...

I have a procedure TheNotificationProcedure that makes a cross-database call to msdb.dbo.sp_send_dbmail. It gets invoked (indirectly) from a service broker queue: CREATE QUEUE [Blah].[TheQueue] WITH ...

I have several queues. One of which has suddenly started acting oddly. It activates repeatedly while nothing is in it's queue. I even manually removed old conversations and this thing is still ...

I'm using Service Broker to [maybe] monitor my database events, so I have my activation sp in some user database and it should react on some events by sending e-mail to admin. But it fails with the ...

We have one SQL Server 2008 on which we run several ETL packages in parallel. This setup has always suffered stability issues. Since I have taken over I am trying to find a way to increase stability ...

I'm investigating a problem with query notifications. The platform is SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Standard Edition. .NET errors show a problem reported from SqlNotificationInfo ...

I have a database running under SQL 2016 that is using service broker to handle some business logic. I did not design the system, I'm still not 100% sure how it works, but I definitely know that it's ...

I encountered a weird SQL Server Service Broker consistency problem, namely I have a queue that holds messages (status=1, Ready to receive) which are lying there for a very long time. In the ...

Our current implementation has a data coming into the system onto a Service broker queue a small amount of processing is performed in case more pertaining data comes in, then a SQL Agent job running ...

1 down vote favorite We have an older vendor supplied application that is earmarked for platform upgrades in 2019 but is currently running SQL Server 2008 (SP4). It's about 1.2TB of data. Our ...

I regularly see code that looks like this: BEGIN TRANSACTION; BEGIN DIALOG CONVERSATION @u.... SEND ... COMMIT; BOL for BEGIN DIALOG doesn't use the transaction handling in the examples and it doesn'...

My target server is not receiving the message and the following error shows in the target servers error logs. Service Broker login attempt failed with error: 'Connection handshake failed. There is no ...

In our estate we've set up Service Broker to perfom an action: Based on a schedule a query is executed and its results are sent, via service broker, to the other service on a remote server Message is ...

I've got a database running on a SQL-Server 2012 DBMS. Consider that the server running SQL Server is not part of the network domain. When I execute this sql command ALTER DATABASE myDatabase SET ...

I've seen it mentioned a few times that you can configure an event session to take an action when an event fires. Does anyone have any information on how to do this? I know that you can use the ...

I have two nodes with MSSQL2012 which work with AlwaysOn High Availability After some crash I had to remove db from availability group on the one of the nodes. For restoration I've made backup (full+...

Having a problem with Event Notifications. On the machine/drive/database that the messages are sent to (receiver), the drive filled up when nobody was looking, so it's been backed up all day. Now ...

Related tags

Hot questions

Language

Popular Tags