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.
Get started using SQL Server Management Studio (SSMS) to connect to your Azure SQL Database and run some Transact-SQL (T-SQL) commands. The article demonstrates how to follow the below steps: Connect to an Azure SQL database.
Open your project in Visual Studio. In Solution Explorer, right-click the Connected Services node, and, from the context menu, select Add Connected Service. In the Connected Services tab, select the + icon for Service Dependencies. In the Add Dependency page, select Azure SQL Database.
Connect with SSMSOn the on-premises client computer, open SQL Server Management Studio. In the Connect to Server dialog box, enter the fully qualified host name for your managed instance in the Server name box. Select SQL Server Authentication, provide your username and password, and then select Connect.
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).
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With