Change the value of ‘Select Top n Rows’ or ‘Edit Top n Rows’ in SSMS 2008

In SQL Server 2008 Management Studio, when you right click on a table, by default you can Select Top 1000 Rows or Edit Top 200 Rows for a selected table:

ITo change the default values, in SQL Server Management Studio:
click Tools -> Options

Expand SQL Server Object Explorer -> click Commands tab:

Change the Value for Edit Top n Rows command and Value for Select Top n Rows command, and click OK:

Value for Edit Top n Rows command
Specifies the number of returned rows using the TOP clause for the Edit command. Specifying a value of 0 returns all rows.

Value for Select Top n Rows command
Specifies the number of returned using the TOP clause for the Select command. Specifying a value of 0 returns all rows.

Now, when you right click on a table, the values for Select Top n Rows or Edit Top n Rows for a selected table will be the new value:

If the post helped you, please share it:

Backup a Single Table in SQL Server 2008 using SSMS

For tables that are not very big, you can create a script using SQL Server Management Studio that you can use to recreate the table (and the data in the table):

1. Right-click the database and choose Tasks > Generate Scripts:

2. In the Choose Objects pane, select the table you want to script

3. In the Set Scripting Options pane, click Advanced.

4. In the Types of Data to Script option, choose Schema and Data

Click ‘Next’ through the remaining screens:

…and you will get a script for recreating the table with data.