SSMS - SQL Azure v12 preview - unknown property IsNativelyCompiled

azure-sql-database ssms
jmw picture jmw · Dec 29, 2014 · Viewed 11.5k times · Source

When I try to view stored procedures in a SQL Azure database (V12 preview) in Management Studio (2014) I get the following error.

TITLE: Microsoft SQL Server Management Studio

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

------------------------------ ADDITIONAL INFORMATION:

unknown property IsNativelyCompiled (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476

Since its in preview I guess that it will be fixed, but is there anyone else who have seen this and in that case have any workarounds until its fixed by MS?

EDIT: It works against on-premise 2014 installations so it seems like its only applies for SQLAzure V12.

Answer

jmw picture jmw · Jan 5, 2015

The solution for me was to download the lastest cumulative update to SQL Server from http://sqlserverbuilds.blogspot.com.es/ (CU5 at the time of writing).

Related questions

Why is running a query on SQL Azure so much slower?

I created a trial account on Azure, and I deployed my database from SmarterAsp. When I run a pivot query on SmarterAsp\MyDatabase, the results appeared in 2 seconds. However, running the same query on Azure\MyDatabase took 94 seconds. I use …

Read More
SSMS 2016 Error Importing Azure SQL v12 bacpac: master keys without password not supported

I have done this dozens of times but just recently ran into this error. Here are the steps I have gone through to get here: Create a copy of my Azure SQL v12 database on the same server as the …

Read More
Reset identity seed after deleting records in SQL Server

I have inserted records into a SQL Server database table. The table had a primary key defined and the auto increment identity seed is set to “Yes”. This is done primarily because in SQL Azure, each table has to have …

Read More