Steps to change default value of SELECT (Top 1000) or EDIT(Top 200) rows in SSMS 2008

As we all aware about the new feature of SQL server 2008, by right clicking any table we can see Select Top 1000 Rows and Edit Top 200 Rows. This feature will give us flexibility to SELECT 1000 rows and EDIT 200 rows just by right click.



Steps to change top Rows:
Step1 : Go to Tools -- Options --> SQL Server Object Explorer --> Commands



Table and View Options:
Value for Edit Top Rows command specifies number of columns to be edited. Default value is 200.

Value for Select Top Rows command specifies number of columns to be selected. Default value is 1000.

Step 2: Change Value for Edit Top Rows Command and Value for Select Rows Command per you requirement.



Step 3: Verify above changes have been made by again right clicking the table.