Remove Row Editing Limitation in SQL Server 2008

In SQL Server 2008 Management Studio Express , we can change the default settings that 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” settings do the following steps.

Step 1:

Run the SQL Management Studio Express 2008 and expand the database and then Tables select the table you can find  option to select Top 1000 Rows and Edit Top 200 Rows as shown bellow.  To change those follow below the steps.

  

Step 2:

Click the Tools -> Options from the menu bar and then you will find Options window.  Form that window Select SQL Server Object Explorer . Now you should be able to see the options as shown in the below window.

Change the Values

*Value for Edit Top Rows Command
*Value for Select Top Rows Command
Give the Values 0 here to select/ Edit all the Records as shown bellow and then click on OK button.

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