No announcements
-
6 VotesAnnouncing Service Broker External Activator
The Microsoft SQL Server Service Broker External Activator (EA) is distributed in the Microsoft SQL Server 2008 Feature Pack. It is an extension of the internal activation feature and lets you move ...Sticky | 13 Replies | 58072 Views | Created by junan - Friday, November 21, 2008 6:24 PM | Last reply by davidbaxterbrowne - Tuesday, January 15, 2013 4:20 PM
Found 1913 threads
-
4 Votes
A transport-level error has occurred in SQL Server when running AccessDatabaseEngine Linked Server Query
I have done this a thousand times, that is, setup the AccessDatabaseEngine on Windows 7 running SQL Server 2008 R2. This time I have done somethings differently, for instance I have Office ...Unanswered | 8 Replies | 6987 Views | Created by Camuvingian - Tuesday, January 19, 2016 10:04 AM | Last reply by LAW YONG SEIN - Monday, July 27, 2020 4:23 PM -
0 Votes
Service broker manager has been started.
I inherited a SQL 2014 environment, and I see this in the log “Service broker manager has been started.”. I also see broker enabled on ...Unanswered | 2 Replies | 3397 Views | Created by HDragos - Wednesday, July 15, 2020 10:41 PM | Last reply by Erland Sommarskog - Thursday, July 16, 2020 8:09 AM -
1 Votes
SQL Service Not Found in Services
hello everyone, i want ask about service sql server (SSMS) in services windows. I already installed ssms 19 but always can't login. After that, i search in services.msc in windows and my ssms service ...Answered | 10 Replies | 4934 Views | Created by Jeco Alviano - Monday, May 18, 2020 11:55 PM | Last reply by Erland Sommarskog - Tuesday, May 19, 2020 9:17 PM -
0 Votes
Service Broker- Similar to Trigger
Hi Guys, We are new to service broker, we want to enable service broker on our server; we have lot of triggers in the SQL server which we want to get rid of and go service ...Unanswered | 2 Replies | 4124 Views | Created by Navind - Tuesday, May 12, 2020 5:59 PM | Last reply by Erland Sommarskog - Tuesday, May 12, 2020 9:40 PM -
0 Votes
Performance Impact
Hi, I'm would like to understand from all the folks using SQL Service Broker if there is any sort of degraded performance on their server due to enabling of this ...Answered | 2 Replies | 4077 Views | Created by Surbhi08 - Tuesday, April 28, 2020 1:39 PM | Last reply by Erland Sommarskog - Tuesday, April 28, 2020 9:15 PM -
0 Votes
SCCM service broker
Primary site server and the replica of the primary site server are connected via AlwaysON. AlwaysOn works fine. Failover , Failback everything is fine. Once after ...Answered | 4 Replies | 6011 Views | Created by KishoreKa - Friday, June 1, 2018 4:57 AM | Last reply by KishoreKa - Tuesday, March 3, 2020 12:38 AM -
2 Votes
Random mail lost with Database mail and non-Microsoft SMTP servers
The following facts was tested and reproduced on 3 completely different environments and with SQL 2005, 2008, 2008R2, 2012 and ...Unanswered | 20 Replies | 11021 Views | Created by Ali Baboun - Monday, October 17, 2016 3:26 PM | Last reply by Tom Phillips - Wednesday, February 5, 2020 4:07 PM -
0 Votes
Service Broker
I just migrated SQL Server 2008 R2 to SQL Server 2017 Standard edition to a different server. I migrated User databases only, not the system databases. Since the migration, I have been getting the ...Unanswered | 1 Replies | 4280 Views | Created by bhaktapur - Monday, January 27, 2020 8:10 PM | Last reply by Erland Sommarskog - Monday, January 27, 2020 10:36 PM -
0 Votes
Trying to follow a SQL Service Broker Step By Step configuration, what am I missing?
I've never used SSB before and is looking to implement this due to an issue we recently had with long running queries executing from a trigger. I'm following the guide below. Looks ...Unanswered | 3 Replies | 5837 Views | Created by ARPRINCE - Tuesday, December 24, 2019 5:20 PM | Last reply by Erland Sommarskog - Tuesday, December 24, 2019 7:53 PM -
0 Votes
Service Broker External Activator Issue
Hi All, I am trying to configure service broker external activator service on SERVER2 ,in my database server (SERVER1) i have two installations of sql server one is 2012 and another ...Unanswered | 4 Replies | 8153 Views | Created by aruntb - Wednesday, January 16, 2019 5:44 PM | Last reply by GoranKaljevic - Thursday, December 12, 2019 5:50 PM -
0 Votes
The session keys for this conversation could not be created or accessed. The database master key is required for this operation. Error
Hi, I'm getting the following error In sys.transmission_queue in the transmission_status column "The session keys for this conversation could not be ...Answered | 2 Replies | 16923 Views | Created by ti2 - Friday, January 20, 2012 5:13 PM | Last reply by panlondon - Thursday, December 12, 2019 10:22 AM -
0 Votes
Service brocker master key error after db refresh
Error details Please create a master key in the database or open the master key in the session before performing this operation.Answered | 2 Replies | 5956 Views | Created by Liju Lalithangathan - Friday, November 1, 2019 6:15 AM | Last reply by Liju Lalithangathan - Monday, November 4, 2019 6:18 AM -
1 Votes
Is service broker a good option?
Hi, I am developing a solution where an external app (.net based) at different client locations would upload CSV files in a queue and SQL server would then pick those files (from ...Unanswered | 1 Replies | 5550 Views | Created by mr_super_genius - Monday, October 14, 2019 5:20 AM | Last reply by Erland Sommarskog - Monday, October 14, 2019 9:52 PM -
0 Votes
Single message stuck in transmission queue
I have single message that will not send in a transmission queue. All other messages of that type work fine. Only error I see is Connection attempt failed ...Unanswered | 3 Replies | 6332 Views | Created by PantsStatusZero - Tuesday, August 20, 2019 11:43 PM | Last reply by PantsStatusZero - Monday, September 9, 2019 5:21 AM -
0 Votes
How should I encrypt/decrypt a TCP/IP data stream ?
I am working on a project which will provide a TCP/IP data stream which will be encrypted on arrival in SQL Server. What would be a good way to decrypt the data stream in SQL Server ...Unanswered | 3 Replies | 5909 Views | Created by Randy Seedle - Wednesday, September 4, 2019 6:10 AM | Last reply by Tom Phillips - Wednesday, September 4, 2019 3:44 PM -
0 Votes
Service broker doing stuff when I don't want it to
Hello, I have recently implemented a Service Broker solution for asynchronous triggers. It seems to work well, but I have a question. We have ...Unanswered | 3 Replies | 6668 Views | Created by dylbud - Monday, August 5, 2019 3:38 PM | Last reply by Dan Guzman - Monday, August 5, 2019 6:51 PM -
0 Votes
Extracing SQL Service Broker Error Fields
I am creating some error handling for the `'SQL/ServiceBroker/Error'` `MessageType` within my queues `Activation Stored Procedure`. While, I have information on how to access the following ...Unanswered | 2 Replies | 8060 Views | Created by Prisoner Z3RO - Monday, January 7, 2019 4:59 PM | Last reply by kjmackey - Friday, July 5, 2019 3:24 PM -
0 Votes
Service broker with multi-subnet
We have a sql server multi-subnet environment with Always On availability groups as our high availability solution. And we'd like to use Service Broker over it. Do you see any issues with this ... -
0 Votes
SQL
My personnel computer is locked out after 2 minutes The people say I must buy a card for 200 or more dollars. What can I do about this??Unanswered | 1 Replies | 6746 Views | Created by BobKer - Saturday, June 8, 2019 4:26 PM | Last reply by Visakh16 - Sunday, June 9, 2019 8:41 AM -
0 Votes
Service Broker and Service Broker and is_trustworthy_on
I use the Service Broker to execute a stored procedure asynchronously simultaneously, using such a queue: CREATE QUEUE MyQueue WITH STATUS=ON , RETENTION=Off , ACTIVATION ...Answered | 6 Replies | 9093 Views | Created by Geri_Reshef - Wednesday, August 5, 2015 5:08 AM | Last reply by Erland Sommarskog - Thursday, May 23, 2019 9:47 PM - Items 1 to 20 of 1913 Next ›
No announcements
