Subscribe to our YouTube Channel for more Videos

SQL Server – Change Edit Top 200 Rows and Select Top 1000 Rows to Select/Edit All

This blog post will explain in simple steps on how you can change the default behaviour in SQL Management studio to change the “Edit Top 200 Rows” and “Select Top 1000 Rows” to Select All.

Have you noticed the Context Menu , when you right click on the table in the SQL Server Management Studio Express 2008 .

The SQL Server Management Studio allows us to “Edit” or “View” the entire records in a table.

You might see the following options in the SQL Server Management Studio Express 2008 .

1. Select Top 1000 Rows

2. Edit Top 200 Rows

The idea to include this looks good for performance reasons .But what if you are a person like me who wants want to display all the records .

In SQL Server 2008 Management Studio Express , you can change the default settings thats allows to edit more than the 200 rows at a time, or select more than 1000 rows

To modify the “Edit Top 200 Rows” or “Select Top 1000 Rows” setttings do the following:

  • Run the SQL Management Studio
  • Click the Tools -> Options
  • Select SQL Server Object Explorer . Now you should be able to see the options
  • Value for Edit Top Rows Command
  • Value for Select Top Rows Command

4. Give the Values 0 here to select/ Edit all the Records

5. Now you should see the Edit All and Select All options on the table .

Senthil Kumar B
Senthil Kumar is a former Microsoft MVP (Most Valuable Professional). He is a Co-Author of the book "Windows 10 Development Recipes using JavaScript and CSS" for Apress Publication. He is a technical presenter, blogger, mentor and a Geek.  Senthil is a regular speaker is various local user groups. He has presented at conferences like Great Indian Developer Summit (GIDS) & Microsoft DevCamps. You can reach out to him via his Twitter handle @isenthil.