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.

23 Responses

  1. Great tip,
    Would you happen to know how to open an edit window without having to find the table and right click on it?
    My database has hundreds of tables, locating the table to right click on is a pain.

Leave a Reply