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.

Advertisements

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

Thanks for the comment, will get back to you soon... Jugal Shah

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s