Change Edit / Select "Top 200 Rows" – SQL Server 2008

The SQL Server 2005 Management Studio allows us to “Edit” and “View” the whole set of records in a table. But in SQL Server 2008 Management Studio, this flexibility was restricted. SQL Server 2008 by default allows us to select top 1000 records and allows us to edit top 200 records. If our records in a table are more than the default numbers, SQL Server 2008 won’t display those records or allows us to edit those records. We can increase those default value.

Steps:

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

We successfully changed the default value to our desired value.