SQL Azure的数据仓库'NOCOUNT“错误 [英] Azure SQL Data Warehouse ''NoCount' Error

问题描述

我刚刚批准了SQL Azure的数据仓库preVIEW，和刚刚完成调配我的新的服务器和数据库。我跟着微软到入门页面的链接（<一个href=\"https://azure.microsoft.com/en-us/documentation/articles/sql-data-warehouse-get-started-connect-query/\"相对=nofollow>开始：。...连接），读这两个最好的（只）查询数据库的方式是通过SQLCMD和Visual Studio 2013

I just got approved for the Azure SQL Data Warehouse Preview, and just finished "provisioning" my new server and database. I followed a link to a 'Getting Started' page from Microsoft (Get started: Connect ...), and read that the two best (only?) ways of querying the database were through sqlcmd and Visual Studio 2013.

我第一次忽略了这一建议，并发射了SSMS，连接到数据库，然后尝试打开一个新的查询窗口。我立即收到以下错误：无法应用连接设置。详细的错误信息是：NOCOUNT不是公认的选项。点击确定后，查询窗口没有打开，但很多T-SQL语句并没有一个简单的工作，例如：

I ignored this advice first, and fired up SSMS, connected to the database, and then tried to open a new query window. I immediately received the following error: 'Unable to apply connection settings. The detailed error message is: 'NoCount' is not a recognized option.' After clicking OK, the query window did open up, but many T-SQL statements did not work such as a simple:

CREATE TABLE dbo.tblTest (acct_id nvarchar(255) NOT NULL)

我会收到成功完成指令（S）。消息，但没有表已创建。

I would receive a 'Command(s) completed successfully.' message, however no table was created.

好吧，我启动了的Visual Studio 2013，连接到我的SQL Azure的数据仓库，并在SQL Server对象资源管理器打开它。我右键单击特定的数据库，并选择新建查询，输入相同的T-SQL CREATE TABLE语句同上，然后点击执行。一旦我打执行，我得到确切同样的错误信息如上。这一次我能够打开一个新的查询窗口，至少，但试图执行查询我仍然得到NOCOUNT以后是不是一个公认的选项错误。

Ok, I fired up Visual Studio 2013, connect to my Azure SQL Data Warehouse, and open it up in SQL Server Object Explorer. I right-clicked the specific database, and selected 'New Query', enter the same T-SQL CREATE TABLE statement as above, then hit execute. Once I hit execute, I get the exact same error message as above. This time around I was able to open a new query window at least, but after attempting to execute the query I still get the 'NoCount' is not a recognized option error.

我是完全新的数据仓库，而且还非常符合T-SQL和SQL Server是初学者也。但是，我一直没能找到任何可以解释为什么我收到这些错误，而现在我处于停滞状态基本上我，直到我能理解这是怎么回事。任何帮助是AP preciated，谢谢。

I'm completely new to data warehouses, and still very much a beginner with T-SQL and SQL Server as well. But, I haven't been able to find anything that would explain why I'm receiving these errors, and right now I'm basically at a standstill until I can understand what's going on. Any help is appreciated, thanks.

推荐答案

我已经经历了这一点。您的连接实际上不是公认的SQL DW连接。我敢打赌，你的查询窗口是一个.sql文件，而不是因为它需要一个.dsql。

I've experienced this. Your connection isn't actually recognised as a SQL DW connection. I bet your query window is a .sql file, not a .dsql as it needs to be.

返回到Azure的门户网站和使用环节使用SSDT从那里来连接。你应该得到的SQL服务器资源管理器面板看起来不同的连接，当你启动基于它的一个新的查询，你应该得到一个.dsql窗口，而不是一个.SQL之一。

Go back into the Azure portal and use the link to connect using SSDT from there. You should get a connection in the SQL Server Explorer pane which looks different, and when you start a New Query based on it, you should get a .dsql window, not a .sql one.

这篇关于SQL Azure的数据仓库'NOCOUNT“错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！