Latest Technology News

Friday, September 12, 2014

Editing ALL rows in MS SQL Server Management Studio 2008

After I upgraded from Microsoft SQL Server 2005 to 2008, one of the first changes that I noticed was the menu that appears when you right-click on a table was missing my beloved ‘Open Table’ option. In the 2005 version, I was able to click this option and my table would open up all the rows in it. This option was replaced by an “Edit top 200 rows” in the 2008 version.

While this is all well and good, why go through the trouble of clicking the “Edit top 200 rows”, and then have to modify the query to have it return all rows? To get rid of the “Edit Top 200 Rows”, go to Tools > Options > SQL Server Object Explorer and in the “Table and View Options“, change the following:

- Value for Edit Top Rows command = 0
- Value for Select Top Rows command = 0

Hit OK. 

And there you have it. When you right-click a table, you will see the option for “Edit All Rows”.

If you have any questions feel free to send an email to  


  1. Thanks , I've recently been searching for information approximately
    this subject for ages and yours is the greatest I have came upon till now.
    However, what in regards to the conclusion? Are
    you certain in regards to the source?

  2. I enjoy gathering useful information, this post has got me even more info!