Service Broker (SSSB)

Handling Service Broker Errors

  • Article

The previous installment of the 'SQL Server 2005 Express Edition' series discussed using transactions to protect the integrity and consistency of Service Broker-based communication. Depending on the type of issue encountered by our code, the outcome might be different from expected. This article demonstrates a more robust approach to error handling and applies it to our target.


1,351 reads

Security Context of Service Broker Internal Activation

  • Article

The previous installment of "SQL Server 2005 Express Edition" discussed Service Broker's internal activation, which allows you to automate communication between initiator and target. Unfortunately, there are some caveats related to its security context. This article describes their specifics and provides a couple of methods to eliminate any undesirable side effects they introduce.


1,164 reads

Configuring Anonymous Dialog Security in SQL Server 2005 Express Service Broker Conversation

  • Article

Recent installments of our series have discussed configuring Service Broker full dialog level security, which required a mechanism to facilitate the exchange of certificates between communication partners. In this article, we will present an alternative approach, which eliminates this requirement by relying on anonymous dialog security.


1,550 reads


Setting default values for Array parameters/variables in Azure Data Factory


(2020-Aug-14) Setting default values for my parameters or variables in Azure Data Factory (ADF)...

Daily Coping 13 Aug 2020


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Homework – August 2020 – More DML Triggers


Well, I’m running a bit late. Both for this month and the fact I...

Read the latest Blogs


Removing TDE from a Database: Level 4 Stairway to TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE from a Database:...

trouble with exec @sql

By polkadot

I want to search all databases having sprocs containing text 'text I am looking...

BDC Orchestration

By Steve Jones - SSC Editor

Comments posted to this topic are about the item BDC Orchestration

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers