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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.