2

I get the following error when I try to expand keys for a table using SSMS 2014 on Azure SQL Server (13.0.702). If I use "Script Table as" I can get a working query. Has anyone else experienced this?

Error:

Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

ADDITIONAL INFORMATION:

unknown property IsMemoryOptimized (Microsoft.SqlServer.Management.Sdk.Sfc)

Information from SSMS:

  • Microsoft SQL Server Management Studio 12.0.2000.8
  • Microsoft Analysis Services Client Tools 12.0.2000.8
  • Microsoft Data Access Components (MDAC) 10.0.10240.16384
  • Microsoft MSXML 3.0 6.0
  • Microsoft Internet Explorer 9.11.10240.16384
  • Microsoft .NET Framework 4.0.30319.42000
  • Operating System 6.3.10240
Ogglas
  • 62,132
  • 37
  • 328
  • 418

2 Answers2

2

The solution for me was to download the lastest cumulative update to SQL Server from http://sqlserverbuilds.blogspot.com.es/

Raj
  • 10,653
  • 2
  • 45
  • 52
1

I downloaded the newest version of SSMS, currently Community Technology Preview 3 (CTP3) and now everything works. Link to latest SSMS:

https://msdn.microsoft.com/en-US/library/mt238290.aspx

Ogglas
  • 62,132
  • 37
  • 328
  • 418