Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

SMO scripting statistics from Azure DWH causes exception

Continued from - https://github.com/Microsoft/sql-xplat-cli/issues/123#issuecomment-319725655

SMO cannot script statistics from Azure SQL DWH.

System.Data.SqlClient.SqlException: Parse error at line: 1, column: 114: Incorrect syntax near 'STATS_STREAM'.
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)

0 votes
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base