O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Related System Catalogs

A few of the system catalogs and dynamic management views (DMVs) might be of interest to you if you’re debugging Service Broker applications or simply seeking a greater understanding of how Service Broker works under the hood. Let’s take a look at some of them.

You’ve already seen sys.transmission_queue, which is used to store undelivered messages in a particular database. This table is useful because it provides the reason a message is undeliverable (in transmission_status), the date sent (in enqueue_time), a conversation identifier (conversation_handle), contract and service names (service_contract_name, to_service_name, from_service_name), and more.

Another useful catalog is sys.service_queues, which holds the definitions ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required