Search code examples
sql-serverssmsssms-2014

SSMS 2014 - Failed to retrieve data for this request - unknown property IsMemoryOptimized

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
Solution

  • 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