SSMS Object Explorer - Select Top N Rows missing w

问题:

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

Mine looks like this:

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?

回答1:

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.

回答2:

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"

回答3:

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.

回答4:

It is now available on SqlServer Mgt Studio 2014.

回答5:

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