This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
A pottery dispatch gate stays closed while an intact vessel waits on a separate inspection bench.

Service Broker Queue: Diagnose a Disabled Receiver

November 29, 2008
Pinal Dave
SQL Tips and Tricks
Service Broker, SQL Error Messages, SQL Transactions

A disabled Service Broker receiver needs diagnosis before recovery. Read queue flags alongside application evidence, distinguish state from cause and check receiving, enqueueing, activation and poison-message handling separately.

Read More
Service broker dialog conversion diagram.

SQL SERVER – Change the Port of Service Broker Configuration

July 20, 2008
Pinal Dave
SQL Tips and Tricks
Service Broker, SQL Scripts, SQL Server

Service Broker hit error 9692 because another app used its port. Here is how to change the port of Service Broker by creating its endpoint on a new port.

Read More
SQL Server - Fix - Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process.

SQL Server – Fix – Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process.

July 19, 2008
Pinal Dave
SQL Tips and Tricks
Service Broker, SQL Error Messages, SQL Scripts

Error 9692 says the Service Broker transport cannot listen on port because another process uses it. Find that program with netstat, or move the port.

Read More
A wrapped parcel waits safely in a receiving cubby beside a prepared delivery shelf.

SQL SERVER – Introduction to Service Broker

July 18, 2008
Pinal Dave
SQL Tips and Tricks
Database Mail, Service Broker, SQL Server

Service Broker supports transactional asynchronous messaging within SQL Server. I separate queued work from the application that processes it.

Read More
Previous 1 2
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com