Editing ALL rows in MS SQL Server Management Studio 2008

Edit all rows in MS SQL Server Management Studio 2008

Edit 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 <n> Rows command = 0
  • Value for Select Top <n> 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”.

16 thoughts on “Editing ALL rows in MS SQL Server Management Studio 2008

Leave a Reply to Laura Preston Cancel reply

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