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


Abuse, Patience, and Understanding


I’ve been struggling with an author for a few months. I tried to work...

Daily Coping 21 Jun 2021


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

SSIS Logging – Linking sysssislog with custom log


I was working on an ETL solution, which was expected to run for hours....

Read the latest Blogs


cumulative updates in multi instance standalone server

By noobdba

For 2019, how would one go about applying CU on multiple instances in a...

Powershell String was not recognized as a valid DateTime

By webrunner

Hello experts, I'm trying to import some CSV data into a SQL database using...

connecting to SQL Database from asp application and setting CONTEXT_INFO

By skb 44459

connecting to SQL Database from asp application and setting CONTEXT_INFO. <connectionStrings> <add name="CLHN_AppConnectionString" connectionString="Data...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers