Remove row editing limitation in SQL 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:


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 we can see the Edit All and Select All options on the table.

Thanks to Rajesh H