Yesterday morning I was able to query my Azure databases via SSMS and the
Select Top N menu shortcut. That afternoon I received a couple of alerts that my web applications couldn't connect to the database.
As a quick check to verify if only that database was down or if all databases on that server were down I connected to the server via SSMS. I was able to view the schema/meta data present in the Object Viewer pane without any problems. I can also execute
SELECT statements against the database when I write the query and/or execute a script. However, when I try to right click a table and use the `Select Top 1000 Rows' shortcut I get an error dialog box with the following message:
Cannot read property IsMemoryOptimized. This property is not available on Windows Azure SQL Database. (Microsoft.AqlServer.Smo)
Today I just noticed that my Azure SQL Database was inexplicably updated from V11 to V12. If this update happened yesterday afternoon that would be the only potential difference in configuration that I am aware of.
- What can I do to suppress this error?
- Why does a
Select top Nshortcut care about the