开发者

I can't use a database in SQL Azure

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜