question

LindellJorgen-7981 avatar image
0 Votes"
LindellJorgen-7981 asked SeeyaXi-msft commented

Why is Query designer still disabled in SQL Management Studio for Azure DB's?

Installed latest SSMS today.

Since a number of versions the query designer is disabled in SSMS for azure database connections, why is this?

It obviously can work, as it is shown when creating a view in such a database, so why not enable it within a query window?

It is really helpful to have when setting up complex joins for example.


/Jörgen

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @LindellJorgen-7981 ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya

0 Votes 0 ·
SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @LindellJorgen-7981,

Welcome Microsoft Q&A!
Not all SSMS functionality from on-premise SQL Server is supported when connected to Azure SQL database. The Query designer is disabled because it's not supported for azure sql database. The general recommendation for managing your Windows Azure SQL Databases is to use the web portal.
Please see this thread, there are some discussions in this thread.

Best regards,
Seeya


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

I did some tracing of what commands that the Query Designer submits to SQL Server, and I found this batch:

DECLARE @edition sysname;
SET @edition = cast(SERVERPROPERTY(N'EDITION') as sysname);
SELECT case when @edition = N'SQL Azure' then 2 else 1 end as 'DatabaseEngineType',
SERVERPROPERTY('EngineEdition') AS DatabaseEngineEdition,
SERVERPROPERTY('ProductVersion') AS ProductVersion,
@@MICROSOFTVERSION AS MicrosoftVersion;
select host_platform from sys.dm_os_host_info
if @edition = N'SQL Azure' 
  select 'TCP' as ConnectionProtocol
else
  exec ('select CONVERT(nvarchar(40),CONNECTIONPROPERTY(''net_transport'')) as ConnectionProtocol')

This fails on SQL Azure, because the DMV sys.dm_os_host_info is not available there.

Not that I understand why this batch is being submitted at all, but I guess they did not find it worth the effort fix this issue. And, in a way, I'm inclined to think that this is a good thing, because there are quite a few things that the Query Designer does not support, so it can more of a roadblock than a help.

But if you think that it should work, you can submit a suggestion here:
https://feedback.azure.com/d365community/forum/04fe6ee0-3b25-ec11-b6e6-000d3a4f0da0

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.