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

sql-server azure azure-sql-database sql-server-2014 ssms-2014
Ryan picture Ryan · Nov 25, 2015 · Viewed 8.2k times · Source

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

Answer

lucaT picture lucaT · Apr 15, 2016

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

Related questions

Optimal way to concatenate/aggregate strings

I'm finding a way to aggregate strings from different rows into a single row. I'm looking to do this in many different places, so having a function to facilitate this would be nice. I've tried solutions using COALESCE and FOR …

Read More
How to view the roles and permissions granted to any database user in Azure SQL server instance?

Could you guide me on how to view the current roles/permissions granted to any database user in Azure SQL Database or in general for a MSSQL Server instance? I have this below query: SELECT r.name role_principal_name, …

Read More
How do I create a new user in a SQL Azure database?

I am trying to use the following template: -- ================================================= -- Create User as DBO template for SQL Azure Database -- ================================================= -- For login <login_name, sysname, login_name>, create a user in the database CREATE USER <user_…

Read More