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.

  1. What can I do to suppress this error?
  2. Why does a Select top N shortcut care about the IsMemoryOptimized property?
  • Not an answer to your question, but Grant Fritchey posted about a similar form of this issue back in April of last year. - scarydba.com/2015/04/07/… . It may not help you, but it may give you a different direction to look.
    – mskinner
    Jan 21, 2016 at 21:34
  • @mskinner That looks promising... Per the help menu my SSMS is version 12.0.4213.0 Which doesn't seem to match a SQL Server 2014 build support.microsoft.com/en-us/kb/2936603
    – Erik
    Jan 21, 2016 at 21:43
  • @mskinner I just updated to the latest version 13.0.900.73 (2016 CTP3) and it is worse. Now I can't even view the list of tables.....
    – Erik
    Jan 21, 2016 at 22:20
  • Well, that stinks!
    – mskinner
    Jan 21, 2016 at 23:08
  • @mskinner Agreed. I submitted a connect item about the 2016 CTP3 issue.
    – Erik
    Jan 21, 2016 at 23:11


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.