Duyuru yok
-
6 Oylar
Announcing 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 ...Yapışkan | 13 Yanıtlar | 58107 Görünümler | Created by junan - 21 Kasım 2008 Cuma 18:24 | Son Yanıt ile davidbaxterbrowne - 15 Ocak 2013 Salı 16:20
Found 1913 threads
-
4 Oylar
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 ...Soru | 8 Yanıtlar | 7036 Görünümler | Created by Camuvingian - 19 Ocak 2016 Salı 10:04 | Son Yanıt ile LAW YONG SEIN - 27 Temmuz 2020 Pazartesi 16:23 -
0 Oylar
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 ...Soru | 2 Yanıtlar | 3446 Görünümler | Created by HDragos - 15 Temmuz 2020 Çarşamba 22:41 | Son Yanıt ile Erland Sommarskog - 16 Temmuz 2020 Perşembe 08:09 -
1 Oylar
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 ...Yanıt | 10 Yanıtlar | 4993 Görünümler | Created by Jeco Alviano - 18 Mayıs 2020 Pazartesi 23:55 | Son Yanıt ile Erland Sommarskog - 19 Mayıs 2020 Salı 21:17 -
0 Oylar
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 ...Soru | 2 Yanıtlar | 4165 Görünümler | Created by Navind - 12 Mayıs 2020 Salı 17:59 | Son Yanıt ile Erland Sommarskog - 12 Mayıs 2020 Salı 21:40 -
0 Oylar
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 ...Yanıt | 2 Yanıtlar | 4113 Görünümler | Created by Surbhi08 - 28 Nisan 2020 Salı 13:39 | Son Yanıt ile Erland Sommarskog - 28 Nisan 2020 Salı 21:15 -
0 Oylar
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 ...Yanıt | 4 Yanıtlar | 6053 Görünümler | Created by KishoreKa - 1 Haziran 2018 Cuma 04:57 | Son Yanıt ile KishoreKa - 3 Mart 2020 Salı 00:38 -
2 Oylar
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 ...Soru | 20 Yanıtlar | 11074 Görünümler | Created by Ali Baboun - 17 Ekim 2016 Pazartesi 15:26 | Son Yanıt ile Tom Phillips - 5 Şubat 2020 Çarşamba 16:07 -
0 Oylar
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 ...Soru | 1 Yanıtlar | 4312 Görünümler | Created by bhaktapur - 27 Ocak 2020 Pazartesi 20:10 | Son Yanıt ile Erland Sommarskog - 27 Ocak 2020 Pazartesi 22:36 -
0 Oylar
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 ...Soru | 3 Yanıtlar | 5875 Görünümler | Created by ARPRINCE - 24 Aralık 2019 Salı 17:20 | Son Yanıt ile Erland Sommarskog - 24 Aralık 2019 Salı 19:53 -
0 Oylar
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 ...Soru | 4 Yanıtlar | 8199 Görünümler | Created by aruntb - 16 Ocak 2019 Çarşamba 17:44 | Son Yanıt ile GoranKaljevic - 12 Aralık 2019 Perşembe 17:50 -
0 Oylar
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 ...Yanıt | 2 Yanıtlar | 16964 Görünümler | Created by ti2 - 20 Ocak 2012 Cuma 17:13 | Son Yanıt ile panlondon - 12 Aralık 2019 Perşembe 10:22 -
0 Oylar
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.Yanıt | 2 Yanıtlar | 6005 Görünümler | Created by Liju Lalithangathan - 1 Kasım 2019 Cuma 06:15 | Son Yanıt ile Liju Lalithangathan - 4 Kasım 2019 Pazartesi 06:18 -
1 Oylar
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 ...Soru | 1 Yanıtlar | 5594 Görünümler | Created by mr_super_genius - 14 Ekim 2019 Pazartesi 05:20 | Son Yanıt ile Erland Sommarskog - 14 Ekim 2019 Pazartesi 21:52 -
0 Oylar
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 ...Soru | 3 Yanıtlar | 6369 Görünümler | Created by PantsStatusZero - 20 Ağustos 2019 Salı 23:43 | Son Yanıt ile PantsStatusZero - 9 Eylül 2019 Pazartesi 05:21 -
0 Oylar
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 ...Soru | 3 Yanıtlar | 5953 Görünümler | Created by Randy Seedle - 4 Eylül 2019 Çarşamba 06:10 | Son Yanıt ile Tom Phillips - 4 Eylül 2019 Çarşamba 15:44 -
0 Oylar
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 ...Soru | 3 Yanıtlar | 6702 Görünümler | Created by dylbud - 5 Ağustos 2019 Pazartesi 15:38 | Son Yanıt ile Dan Guzman - 5 Ağustos 2019 Pazartesi 18:51 -
0 Oylar
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 ...Soru | 2 Yanıtlar | 8101 Görünümler | Created by Prisoner Z3RO - 7 Ocak 2019 Pazartesi 16:59 | Son Yanıt ile kjmackey - 5 Temmuz 2019 Cuma 15:24 -
0 Oylar
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 Oylar
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 ...Yanıt | 6 Yanıtlar | 9134 Görünümler | Created by Geri_Reshef - 5 Ağustos 2015 Çarşamba 05:08 | Son Yanıt ile Erland Sommarskog - 23 Mayıs 2019 Perşembe 21:47 - Items 1 to 20 of 1913 sonraki ›
Duyuru yok