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: