How to Edit More than 200 Rows or View more or less than 1000 rows in SQL Server 2008 /SQL Server 2008 R2

How to Edit More than 200 Rows in SQL Server 2008/2008 R2 Management Studio

Step 1: In SQL Server 2008/2008 R2 Management Studio,

go to "Tools" -> "Options" -> "SQL Server Object Explorer" -> "Commands".

Step 2: Now in "Table and View Options" section, you can change either:

#Value for Edit Top Rows command, to a value greater than or less than 200.
#Value for Select Top Rows command, to a value greater than or less than 1000.

Step 3: By specifying a value of 0, SQL Server will return all rows.

(If your SQL tables are really large data volume, you should NOT set these values to 0.)

Step 4: Click OK to save your changes.