I am trying to use a Database in SQL Azure. I have installed SQL Server 2008. I can Login SQL Azure and can use master Database. But I can't use other Database and I can't see any things in my object explorer. It shows this error:
我试图在SQL Azure中使用数据库。我已经安装了SQL Server 2008.我可以登录SQL Azure并可以使用master数据库。但我不能使用其他数据库,我在对象资源管理器中看不到任何东西。它显示了这个错误:
"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 个解决方案
#1
5
You cannot link to another database server from SQL Azure, whether that other database is SQL Server or SQL Azure.
您无法从SQL Azure链接到另一个数据库服务器,无论该SQL Server还是SQL Azure。
#2
5
I found the Solution for this problem . I install SQL Server 2008 R2. then every thing is ok...
我找到了解决这个问题的方法。我安装SQL Server 2008 R2。那么每件事都可以......
#3
1
-
You can first create only the database before running the whole script to create schemas & Tables.
在运行整个脚本以创建模式和表之前,您可以先创建数据库。
-
Then manually change the database to the new DB that was created.
然后手动将数据库更改为已创建的新数据库。
-
Run the rest of the script. Do not run
Use <databasename>运行脚本的其余部分。不要运行Use
#1
5
You cannot link to another database server from SQL Azure, whether that other database is SQL Server or SQL Azure.
您无法从SQL Azure链接到另一个数据库服务器,无论该SQL Server还是SQL Azure。
#2
5
I found the Solution for this problem . I install SQL Server 2008 R2. then every thing is ok...
我找到了解决这个问题的方法。我安装SQL Server 2008 R2。那么每件事都可以......
#3
1
-
You can first create only the database before running the whole script to create schemas & Tables.
在运行整个脚本以创建模式和表之前,您可以先创建数据库。
-
Then manually change the database to the new DB that was created.
然后手动将数据库更改为已创建的新数据库。
-
Run the rest of the script. Do not run
Use <databasename>运行脚本的其余部分。不要运行Use