How can we improve Azure SQL Database?

Allow the USE statement to switch between databases on the same Azure SQL Server

We use different databases on the same SQL Server as part of a solution and the limitation of not being able to run USE <database> limits us to Azure SQL VMs only instead of using Azure SQL Server.

Per Azure Documentation:

USE statement: To change the database context to a different database you must make a new connection to the new database.

Seems that there should be a way to overcome this limitation. Help us, Microsoft, you are only hope!

266 votes
Vote
Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
You have left! (?) (thinking…)
Arnold shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

11 comments

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    It's like building a car and deciding not to put a steering wheel in. In no other industry would you even consider doing something like this. It's just lazy and shows a complete lack of respect for the users.

  • Anonymous commented  ·   ·  Flag as inappropriate

    come on this should have been there from day one....we should not have to beg for this or vote for this "Feature"

  • Sibte commented  ·   ·  Flag as inappropriate

    A server admin on azure Sql server should atleast be allowed to use 'USE statement'. With database contained user who may not have access to some databases on the same server, I can see why this syntax is not supported.

  • Johnny commented  ·   ·  Flag as inappropriate

    This is one of the most annoying limitations in Azure right now for me.

  • Jorge Merino commented  ·   ·  Flag as inappropriate

    I really miss USE to switch between databases and even having a UNION ALL to show results from similar tables from different Databases. WE NEED THIS FEATURE, bring it on!

  • Marc commented  ·   ·  Flag as inappropriate

    Making a new connection does not work : default database is "master" and it seems not possible to change this.
    Can you show (image please) how you manage to reconnect a SSMS session ?
    Then, why SSMS is it creating script with a top "USE" command if it is not allowed ?

  • Jesus commented  ·   ·  Flag as inappropriate

    We have a lot of scripts with several USE statements. Probably we need to change them to be adapte to not use it. This is unfortunate as it is impacting on time and cost moving to Azure.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Gotta agree with this. Connecting to Azure drops you in Master. Then if you issue a "USE [database];" command, so you can get into your database, you get "USE statement is not supported to switch between databases.".

    It's like trying to reason with a bureaucrat.

Feedback and Knowledge Base