How to change default value of SELECT or EDIT top rows in SSMS 2008 ?

Leave a comment (1) Go to comments

In SQL Server Management Studio 2008, by default, the rows you can Edit or Select are the top 200 and 1000 respectively. What if you have 500 rows and want to edit the last one that too graphically ?

Figure clearly indicates these options with specified number.

How to change default value of SELECT or EDIT top rows in SSMS 2008 ? Value for Select Top Rows command Value for Select Top Audit records command Value for Edit Top Rows command Select top 1000 rows how to increase the select number in SQL server management studio Edit/Select Top N Rows in SQL Server Management Studio Change‘Edit Top 200 rows setting in SSMS 2008 Change Edit Top 200 Rows and Select Top 1000

Solution :  In SQL Server 2008 Management studio, you can change these values as these are user configurable option. To change these setting use the following options

SQL Server 2008 Management Studio >>> Tools >>> OPTIONS >>> SQL Server Object Explorer >>> Commands >>>

How to change default value of SELECT or EDIT top rows in SSMS 2008 ? Value for Select Top Rows command Value for Select Top Audit records command Value for Edit Top Rows command Select top 1000 rows how to increase the select number in SQL server management studio Edit/Select Top N Rows in SQL Server Management Studio Change‘Edit Top 200 rows setting in SSMS 2008 Change Edit Top 200 Rows and Select Top 1000

where you have option to specify,

Value for Select Top <n> Audit records command


Specifies the number of returned rows from a server audit on the log viewer. Specifying a value of 0 returns all rows.

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.

Tags:Value for Select Top <n> Audit records command,Value for Edit Top <n> Rows command,Value for Select Top <n> Rows command,how to increase the select number in SQL server management studio,Change‘Edit Top 200 rows setting in SSMS 2008,Edit/Select Top N Rows in SQL Server Management Studio,Change Edit Top 200 Rows and Select Top 1000,Select top 1000 rows

EOF - How to change default value of SELECT or EDIT top rows in SSMS 2008 ?, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment

1 Comments.

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.