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
And there you have it. When you right-click a table, you will see the option for “Edit All Rows”.
hey great work
Exactly what I needed. Thanks!
Great, thank you for your help!
good…exactly what i want……
You rock!! Thanks!!
Thanks a lot!
Thanks worked great!
Thank you! 🙂
thank u for ur gr8 suggestions
this is nice suggestions but this idea not work SQL 2008 r2 version.
what can i do this version
Thanks, nice suggestions. It seems it also works at SQL 1008 r2
arrrrrrrrrrrrrrrr. worked great. saved my job.