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

Leave a Reply

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