Change the default value of “Edit Top 200 Rows” in 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.

Here are the steps…

1. Open SQL Server 2008 Management studio.

2. Right Click on any of the table. It will display the default value.

3. Go to “Tools” > “Option” > “SQL Server Object Explorer” > “Command”.

4. Change the default value to your desired value. Here i am entering “10000″.

5. Now go and check again. The value gets changed.

We successfully changed the default value to our desired value.
Ref : (sujeev.wordpress.com)