[Bug]: Service Broker objects are not displayed at all

[tuxpoldo]

Description

The object explorer contains the item "Service Broker" with its subitems "Message Types", "Contracts", "Queues", etc. When opening a database with a complex service broker configuration, no service broker objects are displayed under the corresponding "folders".

Steps to Reproduce

1. Connect to a database containing service broker objects
2. In the object explorer expand the folder "Service Broker"
3. In the folder "Service Broker" expand the subfolder "Message Types"
4. "No Items" is displayed, also if your database contains lots of messages type definitions

Affected Area

• Connection dialog (SQL Server | Azure browse/Fabric browse)
• Query editor
• Query results panel
• Object Explorer
• GitHub Copilot integration
• Preview/Edit data
• Table Designer
• Schema Designer
• Schema Compare
• Local SQL Server Container provisioning
• SQL database in Fabric provisioning
• DACPAC/BACPAC export/import
• SQL Database projects
• Query Plan Visualizer
• Other (please describe below)

If you selected "Other", please describe the affected area

No response

Environment Information

Visual Studio Code Version

Version: 1.111.0
Commit: ce099c1ed25d9eb3076c11e4a280f3eb52b4fbeb
Date: 2026-03-06T23:06:10Z
Electron: 39.6.0
ElectronBuildId: 13330601
Chromium: 142.0.7444.265
Node.js: 22.22.0
V8: 14.2.231.22-electron.0
OS: Darwin arm64 25.3.0

MSSQL Tools Version

ms-mssql.mssql-1.41.0/sqltoolsservice/5.0.20260316.3/OSX

Operating System:

macOS Tahoe 26.3.1 (25D2128)

SQL Connection

SQL Server

Confirmation

• I have searched existing issues and couldn't find a match
• I want to work on this issue