SQL Server 2008 – Change Edit Top 200 Rows and Select Top 1000 Rows to Select/Edit 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 Express 2005 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 Express 2008
  • 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 .

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.


  1. Dave Campbell September 13, 2010 Reply
    • Senthil Kumar September 14, 2010 Reply
  2. Visitor September 14, 2010 Reply
  3. jayesh goyani October 4, 2010 Reply
  4. WebSite Guy October 9, 2010 Reply
  5. sapexi October 15, 2010 Reply
  6. Tom Psillas October 25, 2010 Reply
  7. Lakshmi March 4, 2011 Reply
  8. Vi May 2, 2011 Reply
  9. Safiyulla May 10, 2011 Reply
  10. bahman May 25, 2011 Reply
  11. Mauricio June 6, 2011 Reply
  12. larry July 16, 2011 Reply
  13. Srikanth August 11, 2011 Reply
  14. LAKS September 23, 2011 Reply
  15. YesZone November 13, 2011 Reply
  16. jeff March 27, 2012 Reply
  17. Abel June 1, 2012 Reply
  18. shambhoo kumar January 21, 2014 Reply
  19. Ahsan January 31, 2014 Reply

Leave a Reply


Interesting BlogPosts to read

Column Alias and Square brackets in SQL Query.
When we want to specify a alias for a column in SQL Query , we tend to use the double quotes or sing...
Getting started with node.js, Express and Mongoose
I started tinkering with some test data creation scripts using Node.js a while back, but it’s been o...
How to get the MAX row with group by in LINQ query using C# ?
Below is a sample code snippet demonstrating how to retreive the max row with the group by in LINQ Q...