How to select more than 1000 rows by default in SQL Server Management Studio

In SQL Server Management Studio when we right-click a table we have an option to ‘Select Top 1000 Rows’ and ‘Edit Top 200 Rows’ as shown below…

Select Top 1000 Rows

SQL Server Management Studio chooses these relatively low defaults to prevent unresponsive GUIs however we can increase these if we wish through SSMS options…

Configure how many records to view/edit


You might also be interested in...

How to set scripting defaults in SQL Server Management Studio
In SQL Server Management Studio when you use the DB (right click) -> Tasks -> Generate Scripts option to export … Continue reading How to set scripting defaults in SQL...

Setting connection status bar colour in SQL Server Management Studio
In SQL Server Management Studio we can set the colour of the status bar when we’re connecting to a particular … Continue reading Setting connection status bar colour in SQL...

How to show query window on startup in SQL Server Management Studio
A lot of time the first thing we do when we startup SQL Server Management Studio is to open a … Continue reading How to show query window on startup...

Showing line numbers in SQL Server Management Studio
Line numbers are not displayed by default in SQL Server Management Studio (SSMS) but… they are super helpful if you’re … Continue reading Showing line numbers in SQL Server Management...

How to refresh Intellisense in SQL Server Management Studio (SSMS)
When we create or change an object in SQL Server Management Studio, the IntelliSense often doesn’t know about these changes. … Continue reading How to refresh Intellisense in SQL Server...

Leave a Reply

Your email address will not be published. Required fields are marked *