SQL 2008 – Change ‘Edit Top 200 Rows"
Well this is a great idea from Microsoft, but what if you want them all, or you want more then 200 rows like me, I am greedy, I like everything….
Any ways I was prepared to hack the registry for this one, but it seems you dont have to, and its in very simple to do and find… But I have one of my dev’s point it out to me as I seemed to have been blind to this, even though I was looking for it for hours, and even went into the options console…
Lesson 1 learnt, late nights and SQL don’t mix.
Lesson 2 Change the Top 200 rows
go to
Tools
Options
SQL Server Object Explorer, Expand this tree
Choose ‘Commands’
And there you go change it to your desired amount, 0 = everything!
Cheers
January 20th, 2009 at 8:03 am
[...] - MOVED Posted by bradmarsh under Microsoft, Software, Techie This Post has moved to : http://bradmarsh.net/index.php/2008/04/21/sql-2008-change-edit-top-200-rows/ [...]
January 29th, 2009 at 12:30 am
hi
sometimes feeling that our posts can be useful for someone in this big world is very good feeling .
well I should say a well done to you and thanks for your good help to me , regards from Iran !
February 18th, 2009 at 3:45 am
Nice post, Brad!
February 26th, 2009 at 4:11 am
Thank you so much. I upgraded from 05 yesterday and if I hadn’t found this post I would have been back to it tomorrow because this was annoying.
February 26th, 2009 at 12:25 pm
your most welcome, Took me a while to find this one as well, very annoying (but also useful if your quering a table and your not sure how many records it has)
May 29th, 2009 at 7:34 pm
nice tip! need to figure out how to do a query that allows a gui edit…..
August 11th, 2009 at 2:35 am
Thanks. Another question… is there any other way to open an editable grid other than the “Open top 200…”. You can always do Open Top 200 then modify the SQL query, but it would be nice if you could just open an editable query and type your SQL. Thanks.
August 23rd, 2009 at 3:24 pm
below this show top .. there is a edit top 200 this will open a grid you can edit
September 9th, 2009 at 6:09 pm
Great!
when i want to modify the 201th row, I come to your blog
September 19th, 2009 at 3:41 am
Thank you!
October 1st, 2009 at 3:24 am
This helps a lot. Appreciate it!
October 3rd, 2009 at 6:01 am
Thanks A Mil!! This saved me hours of my time
October 18th, 2009 at 5:09 pm
I had feared the “Select rows” and “Edit rows” number was not changeable … thanks for showing how to change these values Brad! Glad your post was high on Google’s search results.
December 11th, 2009 at 8:35 pm
[...] das SQL Management Studio 2008 nur die ersten 200 Zeilen editieren lässt, findet hier die Lösung: http://bradmarsh.net/index.php/2008/04/21/sql-2008-change-edit-top-200-rows/ Tags » Trackback: Trackback-URL | Feed zum Beitrag: RSS 2.0 [...]
December 15th, 2009 at 1:38 am
Great!
Thank you very much!
January 28th, 2010 at 10:31 pm
Thanks! Very useful
February 18th, 2010 at 10:33 pm
Fabulous. I am not a programmer but need to adjust data inour prototype for a demonstration. You saved me mnay hours for work. Thank you very much!
March 23rd, 2010 at 2:42 pm
any way to edit “bottom 200″?? There is an option for top 200 but can I modify this? Thx
April 30th, 2010 at 1:25 am
This is great.
Thank you very much!!!
May 19th, 2010 at 11:30 am
[...] SQL 2008 – Change “Edit Top 200 Rows” Possibly related posts: (automatically generated)SQL to Select Random Rows from TableCreate Serial [...]
July 22nd, 2010 at 8:53 pm
Thank you very much for your post!
I feel much better now.
Very useful is also how to get back the the Ctrl-N shortcut with SQL Server 2008 Management Studio. See below:
http://anotherlab.rajapet.net/2009/03/getting-back-ctrl-n-shortcut-with-sql.html
September 16th, 2010 at 7:31 am
Perhaps a better way is to leave it at 200 rows, run the query, then after the results are shown, you click the “Show SQL Pane” button. You can edit the query anyway you like including the number of rows and even put in a where clause or two (even better!).
January 5th, 2011 at 10:42 pm
Perfect, just what I was looking for
July 27th, 2011 at 6:09 pm
That is awesome! Nice work this post was worth my time. Looking forward to your future post.. Thanks for sharing.
August 16th, 2011 at 3:26 pm
I was surprised the amount of this I just didn’t know. Thanks for writing this info. I’ll be certain to come back right here to find if there is any kind of brand-new information.
September 21st, 2011 at 5:17 am
Thanks a lot!