SSMS - SQL Azure v12 preview - unknown property IsNativelyCompiled

28
votes

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.

1
azure-sql-databasessms
That is very strange because SSMS 2014 is aware of natively compiled procedures. They exist starting with 2014. Do you have preview software on your machine? – usr
No I dont, also made sure that no plugins are enabled that perhaps could have caused this behaviour. – jmw
Did a repair of SSMS but it did not solve the problem. – jmw

1 Answers

24
votes

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).