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:

1. Run the SQL Management Studio Express 2008
2. Click the Tools -> Options
3. 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 .

Ref: http://www.ginktage.com/2010/09/sql-server-2008-change-edit-top-200-rows-and-select-top-1000-rows-to-selectedit-all/