Knowledgebase: MSSQL Server
How to Edit More than 200 Rows in SQL Server 2008 Management Studio
Posted by on 13 February 2013 07:13 PM

If you want to change the default settings to allow you to edit more than the 200 rows at a time, or select more than 1000 rows, which are the default settings for Microsoft SQL Server.  To modify “Edit Top 200 Rows” or “Select Top 1000 Rows”  settings do the following:


In SQL Server 2008 Management Studio, go to “Tools” -> “Options” -> “SQL Server Object Explorer” -> “Commands“.
Now in the right-hand side “Table and View Options” section, you can change either:
Value for Edit TopRows command, to a value greater than or less than 200.
Value for Select TopRows command, to a value greater than or less than 1000.
By specifying a value of 0, SQL Server will return all rows.  (If you sql tables are really large, you will definitely NOT want to set these values to 0.
Click OK to save your changes.

(43 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).