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!
This is not currently planned at this time. Will keep this item open for voting and comments.
Definitely a con for cloud convenience. Please add!
Nigel Spicer commented
As requested by others on here can the support for the USE statement please be added
Please add use command. I don't know any cons of not having it.
this is useful also when trying to create an automate script which creates a schema , some objects inside , creates a Login ( which should be created from master ) , creates a user using the new created login and after allow access to the new created user to the new created schema. I thins this is a must have feature for such scenarios.
Not having this is the dumbest thing. even when opening a new SQL tab in SSMS I'm so used to typing USE [dbname] . It's faster than having to use the mouse and move up to change the drop-down.
So dumb Microsoft, so dumb ... please bring it in.
This is definitely a must have for Azure SQL, else it does not make it easy to use and as similar to on-premise SQL Server..
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.
please add USE
come on this should have been there from day one....we should not have to beg for this or vote for this "Feature"
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.
This is one of the most annoying limitations in Azure right now for me.
Jorge Merino commented
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!
Please bring in this feature !
Any updates? This is really stopping us from many projects.
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 ?
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.
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.