Unable to expand or display column nodes of SQL Azure database connected in SQL Server Management Studio 2014

Sometimes when you are working on a SQL Azure database using SQL Server Management Studio, you might encounter a strange issue of not able to expand the tables to list down the column nodes or display the column nodes. I am using SQL Server 2014 and I had been facing this issue for a long time.

The error might say any of the following:

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476

unknown property IsMemoryOptimized (Microsoft.SqlServer.Management.Sdk.Sfc) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476

Finally I was able to solve this issue by updating my SQL Server 2014 with Service Pack 1 downloaded from the following link https://www.microsoft.com/en-us/download/details.aspx?id=46694

Hope this will provide a resolution for someone who is encountering the same issue.

Leave a Reply

%d bloggers like this: