SSMS Object Explorer - Select Top N Rows missing when connected to Azure DB

Question

I just upgraded my SSMS to 2008 R2. I'm missing the option to select the top 1000 rows from a table, like this:

enter image description here

Mine looks like this:

enter image description here

I know how to change the number of rows that are displayed, but the options aren't there at all. I saw that someone submitted a bug for this a few years ago, but there was no workaround, and I'm not sure what to do. Any ideas?

EDIT - Azure Problem?

I just used SSMS to open my local SQL Server, and I get the option to select the top 100 rows. But in my other SSMS instance, the one that is connected to my Azure DB, I don't see it. Is it possibly an Azure limitation?

score 16 · Accepted Answer · edited May 23 '17 at 12:08

16

Based on this answer, I believe it is a limitation of SQL Azure. I have not been able to find any additional information that would allow you to work around the issue.

edited May 23 '17 at 12:08

Community

1
1

answered Feb 08 '13 at 01:21

UnhandledExcepSean

12,504
2
35
51

That answer is almost two years old, so I hope it's no longer correct. :) Anyway, if no one can tell me otherwise, I'll accept this as the answer. Thanks! – Bob Horn Feb 08 '13 at 01:26
1

@SpectralGhost is correct; Azure doesn't allow SSMS to query data in the same way as SQL Server, as they're still not the same product. Simply write a SELECT statement to bring back the 200 or so records you want/need. – Brett Rigby Feb 08 '13 at 11:43
It is now available on SqlServer Mgt Studio 2014. I also added an answer to this post for ease of searching. And I have not downloaded the hotfix but I do see it listed as a fix. – DanO Nov 12 '15 at 14:55
It is NOT a limitation of SQL Azure, it is a limitation of your client or SSMS version. – webStuff Jul 26 '17 at 04:25

score 4 · Answer 2 · answered Apr 06 '15 at 14:51

4

As of 06/04/2015 MS has published a hotfix to solve this issue.

http://support.microsoft.com/en-us/kb/3011055

"An update is available that enables "Select Top 1000 Rows" option for tables and views of SQL Azure database"

answered Apr 06 '15 at 14:51

ysrb

6,693
2
29
30

1

Prefer downloading the Service Pack 2 update: https://www.microsoft.com/en-us/download/details.aspx?id=53168 – webStuff Jul 26 '17 at 04:28
The download link is no more valid. You can download Service Pack 2 as @webStuff suggested – Popa Andrei Oct 17 '17 at 12:25

score 2 · Answer 3 · answered Feb 08 '13 at 14:00

You do not have this option in SSMS while working with SQL Azure, you have to exexute the query yourself ... select top 10000 from tablename

There are few other options as well in SSMS which are not displayed in case of SQL Azure.

This is an excpected behaviour for SQL Azure.

score 1 · Answer 4 · answered Nov 12 '15 at 05:54

1

It is now available on SqlServer Mgt Studio 2014.

answered Nov 12 '15 at 05:54

DanO

407
5
15

Only available in SSMS 2014 for build greater than 12.0.20xx.x You can install the Service Pack 2 (build 12.0.50000.0) if you have a older build: https://www.microsoft.com/en-us/download/details.aspx?id=53168 – webStuff Jul 26 '17 at 04:23

score 0 · Answer 5 · answered Feb 08 '13 at 01:08

0

Check that you have correct values in the SQL Server Object Explorer Settings:

enter image description here

answered Feb 08 '13 at 01:08

Preet Sangha

64,563
18
145
216

Thanks, but my settings are exactly like that. – Bob Horn Feb 08 '13 at 01:12
1

I just edited my question to provide more information. Possibly an Azure issue? – Bob Horn Feb 08 '13 at 01:14

SSMS Object Explorer - Select Top N Rows missing when connected to Azure DB

5 Answers5

Linked