All geek questions in one place

I cannot use database in SQL Azure

I am trying to use a database in SQL Azure. I installed SQL Server 2008. I can log in to Azure SQL and use the underlying database. But I cannot use another database, and I do not see anything in my object explorer. It shows this error:

"USE statement is not supported to switch between databases. Use a new connection to connect to a different Database."

How can I use another database?

+3
source share
3 answers

I found a solution for this problem. I install SQL Server 2008 R2. then everything is fine ...

+3
source

You cannot reference another database server from SQL Azure, regardless of whether this other database is SQL Server or SQL Azure.

+4
source

  • You can only create a database first before running the entire script to create schemas and tables.

  • Then manually change the database to the newly created database.

  • Run the rest of the script. Do not runUse <databasename>

0
source

Source: https://habr.com/ru/post/1746985/

More articles:


All Articles