Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

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

Tags:

sql-server

sql-server-2008

ssms

azure-sql-database

azure

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?

like image 364
Bob Horn Avatar asked Feb 08 '13 01:02

Bob Horn

People also ask

Can you connect SSMS to Azure SQL Database?

Open SQL Server Management Studio to connect to the database name using SQL Server authentication and the SA user you set up earlier. If you haven't setup the firewall rule already, you will be prompted by SSMS to authenticate with your Azure account.

Can't connect to Azure SQL Database from SSMS?

SSMS cannot connect to azure sql databaseYour client IP address does not have access to the server azure. Sign in to an Azure account and create a new firewall rule to enable access. This is for obvious security reasons. You don't want to allow everyone to be able to connect to your sql database in azure.

Does SQL search work with Azure?

Start using SQL Search for Azure Data Studio A - Launch SQL Search using Ctrl/Cmd+Shift+p , then SQL Search .

How do I link my Azure SQL managed instance to SSMS?

Connect with SSMSOn the on-premises client computer, open SQL Server Management Studio. In the Connect to Server dialog box, enter the fully qualified host name for your managed instance in the Server name box. Select SQL Server Authentication, provide your username and password, and then select Connect.

2 Answers

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.

like image 65
UnhandledExcepSean Avatar answered Oct 06 '22 00:10

UnhandledExcepSean

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"

like image 43
ysrb Avatar answered Oct 06 '22 01:10

ysrb
Sign in to Comment

Related questions

How to optimize a table for fast inserts only?
Using transaction on a single update statement
Group tables by schema in SSMS
Cross Apply Including Nulls
How to force SQL Server to return empty JSON array
How to get the IDENTITY value when using INSERT ... OUTPUT with pyodbc
Store files in database using Entity Framework Core
Sql Table data type for email address?
Temporary Value Error During Entity Framework Core Modify
SQL Server - Invalid characters in parameter names
Return rows between a specific range, with one select statement
Cannot persist computed column - not deterministic
Pros/Cons Using multiple databases vs using single database
FOR XML PATH(''): Escaping "special" characters
Sql - goto statement
Daily SQL Task to delete contents from a table
Undesired rounding of DateTime in SQL Server
SQL comma-separated row with Group By clause
SQL Wildcard Search - Efficiency?
Change column from VARCHAR(MAX) to VARBINARY(MAX)

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!