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
Diagram of two SQL Server instances, each with a Service Broker holding Message, Contract and Service, joined by a dialog conversation; the two BrokerEndpoint boxes talk over TCP and the LISTENER_PORT value 5000 is marked in red

Change Service Broker Port: Drop and Recreate the Endpoint

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

Service Broker hit error 9692 because another application used its port. To change Service Broker port, drop the endpoint and create it again on a new port. Both scripts are here.

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