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

Twitter This

This entry was posted on Monday, April 21st, 2008 at 12:04 am and is filed under Microsoft, Software, Techie . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

26 Responses to “SQL 2008 – Change ‘Edit Top 200 Rows"”

SQL 2008 - Change ‘Edit Top 200 Rows’ - MOVED « Brad Marsh’s Weblog Says:
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/ [...]
Mahyar Says:
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 !
Paul Smietan Says:
February 18th, 2009 at 3:45 am
Nice post, Brad!
Bob Glasser Says:
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.
Brad Marsh Says:
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)
Lenn Dolling Says:
May 29th, 2009 at 7:34 pm
nice tip! need to figure out how to do a query that allows a gui edit…..
LC Says:
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.
Brad Marsh Says:
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
Jack Says:
September 9th, 2009 at 6:09 pm
Great!
when i want to modify the 201th row, I come to your blog
Peggy Scott Says:
September 19th, 2009 at 3:41 am
Thank you!
Asif Rehmani Says:
October 1st, 2009 at 3:24 am
This helps a lot. Appreciate it!
Francois Compion Says:
October 3rd, 2009 at 6:01 am
Thanks A Mil!! This saved me hours of my time
Rusty Manheim Says:
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.
pan-fry » Edit top 200 rows – oder auch mehr… « Says:
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 [...]
Danny Neufkens Says:
December 15th, 2009 at 1:38 am
Great!
Thank you very much!
Denisa Says:
January 28th, 2010 at 10:31 pm
Thanks! Very useful
Greg Says:
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!
Ryan Cramer Says:
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
Henry Williams Says:
April 30th, 2010 at 1:25 am
This is great.

Thank you very much!!!
SSMS 2008: change default SELECT/EDIT TOP (n) rows command « a developer’s breadcrumb Says:
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 [...]
Charles Rex Says:
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
NSBill Says:
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!).
Thomas K. Nielsen Says:
January 5th, 2011 at 10:42 pm
Perfect, just what I was looking for
Small boat building Says:
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.
Geraldine Hourihan Says:
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.
Martin Bravo Says:
September 21st, 2011 at 5:17 am
Thanks a lot!