Service Broker (SSSB)

SQL Server Service Broker Poison Message Handling

  • Article

Have you ever figured out why your Service Broker queue gets disabled automatically? What causes your Service Broker queue to get disabled in the first place? What is a poison message with respect to Service Broker? Is there anything new in SQL Server 2008 R2 for managing poison messages in Service Broker?

2011-04-04

3,619 reads

Blogs

The Manager’s Guide to Git Training for DBAs (Video / Podcast)

By

Learning Git can be daunting for DBAs. In this 20 minute episode, I discuss...

Snowflake – Understanding constraints

By

One of the concepts in Snowflake that I find many struggle with is how...

Getting a List of Tags from the Microsoft Container Registry–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

Sum Pivot by Dynamic Quarter

By girl_bj

i have a report to create a prediction for 12 months (yearly prediction by...

Binary(Document) Extraction using SSIS - derived column

By CanIKickIT

Hello all - I'm reaching out for some pointers regarding a task I have...

View will not run from System Databases

By terry999

I'm planning an upgrade to SQL 2017 standard edition from 2008 workgroup Edition. On...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers