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:

To 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:
Pin It

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">