Ability to use a single table for all uniquely identified instances of an endpoint (via a discriminator)

[SzymonPobiega]

Describe the feature.

Is your feature related to a problem? Please describe.

When unique instance IDs are used the NServiceBus uses a separate queue for each endpoint instance (adding a suffix based on the provided instance discriminator).

Each such queue requires a dedicated table in SQL Server transport. That leads to problems when instances are created (and removed) dynamically (elastic environments). One way to overcome the problem is to enable installers but that's not a good solution in environments that follow the least privilege approach to security. Installers would now help with removing the queues no longer used.

Describe the requested feature

Have a shared table for all the discriminated queues. One way of achieving that would be to use a "discriminator" column.

Describe alternatives you've considered

Additional Context

No response