开发者

I can't use a database in SQL Azure

开发者 https://www.devze.com 2022-12-31 07:18 出处:网络
I am trying to use a Database in SQL Azure. I have installed SQL Server 2008. I can Login SQL Azure and can u开发者_运维技巧se master Database. But I can\'t use other Database and I can\'t see any thi

I am trying to use a Database in SQL Azure. I have installed SQL Server 2008. I can Login SQL Azure and can u开发者_运维技巧se master Database. But I can't use other Database and I can't see any things 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?


You cannot link to another database server from SQL Azure, whether that other database is SQL Server or SQL Azure.


I found the Solution for this problem . I install SQL Server 2008 R2. then every thing is ok...


  1. You can first create only the database before running the whole script to create schemas & Tables.

  2. Then manually change the database to the new DB that was created.

  3. Run the rest of the script. Do not run Use <databasename>

0

精彩评论

暂无评论...
验证码 换一张
取 消