How to Edit More than 200 Rows in SQL Server 2008 Management Studio
Change the default settings of "Edit Top 200 Rows" or "Select Top 1000 Rows" in SQL Server 2008 Management Studio.
Updated April 5, 2012
Modify the default settings in SQL Server Management Studio, to Edit more than 200 rows or Select more than 1000 rows.
In SQL Server 2008 Management Studio, you may 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 SQL Server. To modify "Edit Top 200 Rows" or "Select Top 1000 Rows" setttings 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.
You can also open up the SQL pane and change the query for SELECT TOP (200). To do this follow these steps:
- In the Object Explorer, right click on the Table you want to edit and select "Edit Top 200 Rows"
- Once the 200 rows populate in the Main window, right click anywhere in the Main pane and click -> Pane -> SQL.
- A "SQL Pane" will open up above your Table of 200 rows, where you can then change the SELECT statement to query as many rows as you would like.