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 | 51036 Views | Created by junan - Friday, November 21, 2008 6:24 PM | Last reply by davidbaxterbrowne - Tuesday, January 15, 2013 4:20 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 | 491 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 | 275 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 | 457 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 | 1776 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 | 716 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 | 2515 Views | Created by Geri_Reshef - Wednesday, August 5, 2015 5:08 AM | Last reply by Erland Sommarskog - Thursday, May 23, 2019 9:47 PM -
2 Votes
The target service name could not be found. Server version compatibility problem?
Hi, I have two remote SQL Servers. One initiator another one is target. Now I need to move target to new server and new database just with SAME database ...Unanswered | 2 Replies | 883 Views | Created by Natip - Friday, May 10, 2019 2:49 PM | Last reply by Natip - Monday, May 13, 2019 11:05 AM -
0 Votes
Replictaing data to multiple instance
Hi everyone, I have two below questions regarding service broker, I would appreciate if someone help me on those. 1- Is it possible to replicate data from one sql ...Unanswered | 1 Replies | 1362 Views | Created by Mourmansk - Friday, March 29, 2019 6:37 PM | Last reply by Hilary Cotter - Friday, March 29, 2019 8:18 PM -
0 Votes
An entity of type service cannot be owned by a role, a group, or by principals mapped to certificates or asymmetric keys.
I'm using SQL Server 2008 R2 and a WCF service in Visual Studio 2010. I am trying to set up a SQL Dependency to detect changes in the database, and I have set up a queue and service. I keep getting ...Answered | 11 Replies | 4507 Views | Created by Lane95 - Monday, August 8, 2016 7:06 PM | Last reply by Lane95 - Tuesday, February 26, 2019 9:07 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 | 3 Replies | 1732 Views | Created by aruntb - Wednesday, January 16, 2019 5:44 PM | Last reply by flopirr - Tuesday, January 22, 2019 7:26 PM -
0 Votes
Service Broker Waitfor Receive and Activation Procedure
Can anyone explain this concept to me: In Service Broker (SQL Server) a queue can be configured with an "activation" procedure. This is a procedure ...Answered | 5 Replies | 1946 Views | Created by dylbud - Thursday, November 29, 2018 7:46 PM | Last reply by dylbud - Friday, November 30, 2018 11:27 PM -
2 Votes
No enabled application monitor is on behalf of queue...
Hello, I am trying to set up external activation, and the external application doesn't ever seem to be launched. I get the following error, which shows up in the ...Answered | 4 Replies | 15616 Views | Created by Mark Shoemaker - Tuesday, October 27, 2009 2:17 PM | Last reply by Hugh C Jones - Wednesday, November 28, 2018 10:04 AM -
0 Votes
Broker:Connection_Connection handshake failed. An OS call failed: (8009030c) 0x8009030c(The logon attempt failed). State 67__
I am trying to send a message between 2 different instances in the same domain.I am getting the above error.The SQl Server is logged on as NTService\MSSQlSERVER in both the instance.I am not ...Unanswered | 4 Replies | 1920 Views | Created by RobinThomas8687 - Monday, November 19, 2018 9:41 AM | Last reply by RobinThomas8687 - Tuesday, November 20, 2018 1:36 AM -
0 Votes
Connection attempt failed with error: 10060
I used the example "Completing a Conversation Between Instances" from SQL Server 2008 Books Online, but when I try to send a message, it does not go through, and in ...Answered | 13 Replies | 45047 Views | Created by dr938 - Monday, October 20, 2008 7:12 AM | Last reply by RobinThomas8687 - Monday, November 19, 2018 8:48 AM -
0 Votes
SERVICE BROKER ENDPOINT WITH CERTIFICATION
Hi All, How do we use SERVICE BROKER ENDPOINT FOR 2 SQL INSTANCES ON SAME SERVER . How do we migrate the ENDPOINT WITH CERFICATE FROM SQL SERVER 2008 to SQL SQL ...Unanswered | 1 Replies | 2049 Views | Created by Vanchan007 - Saturday, October 27, 2018 8:35 AM | Last reply by Erland Sommarskog - Tuesday, October 30, 2018 10:39 PM -
1 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 | 17 Replies | 3630 Views | Created by Ali Baboun - Monday, October 17, 2016 3:26 PM | Last reply by pfmathieu - Tuesday, October 30, 2018 6:08 PM -
0 Votes
SQL SERVER MIGRATION ISSUE
WE MIGRATED DATABASE FROM SQL SERER 2008 TO SQL 2016 alwasyon, facing sorting issue at application but DB side records are being sorted correctly but the same database on stand alone no ...Unanswered | 1 Replies | 1874 Views | Created by Vanchan007 - Monday, October 29, 2018 5:52 AM | Last reply by Erland Sommarskog - Monday, October 29, 2018 10:39 PM -
0 Votes
SQL SERVER
dir sqx.exe C:\Program Files\Microsoft SQL Server\MSSQL13.SQLCLU1\MSSQL\Binn>sqlservr -m -T4022 -T3659 -s"QAPERFORMANCE\SQLCLU1" ...Unanswered | 1 Replies | 1980 Views | Created by Vanchan007 - Sunday, October 28, 2018 7:26 PM | Last reply by Erland Sommarskog - Sunday, October 28, 2018 10:25 PM -
0 Votes
Same server broker for mutiple sql server insatnces
How the same server broker endpoint will work for multiple sql server instances same windows serverUnanswered | 2 Replies | 1937 Views | Created by Vanchan007 - Saturday, October 27, 2018 6:19 PM | Last reply by Erland Sommarskog - Saturday, October 27, 2018 6:32 PM - Items 1 to 20 of 1905 Next ›
No announcements
