Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Server Management Studio 2014: Unable to view stored procedures on Azure SQL Database V12

I have updated SQL Server Management Studio to the latest version at time of writing - 12.0.4432.0 - this is SP1 with CU3 and additional bug fixes. My Azur SQL Database version is 12.0.2000.8

I can not view any stored procedures through the GUI, when I try I get this error (all other functionality appears to be working normally):

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)

Help>About

Microsoft SQL Server Management Studio                      12.0.4432.0
Microsoft Analysis Services Client Tools                        12.0.4432.0
Microsoft Data Access Components (MDAC)                     6.1.7601.17514
Microsoft MSXML                     3.0 5.0 6.0 
Microsoft Internet Explorer                     9.11.9600.17801
Microsoft .NET Framework                        4.0.30319.42000
Operating System                        6.1.7601
like image 453
Ryan Avatar asked Mar 14 '23 01:03

Ryan


1 Answers

I had the same problem, I have download the service pack 1 (https://www.microsoft.com/en-us/download/confirmation.aspx?id=46694) and I resolve

like image 176
lucaT Avatar answered Mar 17 '23 05:03

lucaT