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 me@rajeshgoutam.com  

19 comments:

  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?

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

    ReplyDelete
  3. I like the helpful info you supply to your articles.
    I will bookmark your blog and test once more here regularly.
    I am reasonably certain I'll learn many new stuff right right here!
    Best of luck for the following!cheap jerseys

    ReplyDelete
  4. What's up to every , for the reason that I am actually keen of reading this blog's post to be updated daily.
    It includes fastidious stuff.cheap NBA jerseys

    ReplyDelete
  5. Hello, I wish for to subscribe for this webpage to obtain most recent updates,
    therefore where can i do it please help.

    ReplyDelete
  6. Appreciating the hard work you put into your blog and detailed information you
    present. It's good to come across a blog every once in a while that isn't the same old rehashed information. Great read!
    I've saved your site and I'm including your RSS feeds to my Google account.

    ReplyDelete
  7. Thanks for ones marvelous posting! I actually enjoyed reading it, you are a great author.
    I will make sure to bookmark your blog and definitely will
    come back very soon. I want to encourage one to continue your great posts, have a nice afternoon!wholesale MLB jerseys

    ReplyDelete
  8. Pretty section of content. I just stumbled upon your site
    and in accession capital to assert that I get actually enjoyed account your blog posts.
    Anyway I will be subscribing to your augment and even I achievement you access consistently rapidly.cheap jerseys

    ReplyDelete
  9. I was curious if you ever considered changing the layout of your site?

    Its very well written; I love what youve got to say. But maybe you could a little more
    in the way of content so people could connect with it better.
    Youve got an awful lot of text for only having one or two images.
    Maybe you could space it out better?

    ReplyDelete
  10. It's awesome to visit this website and reading the views of all friends regarding this piece of writing, while
    I am also keen of getting familiarity.

    ReplyDelete
  11. Good article! We will be linking to this great article on our website.
    Keep up the great writing.wholesale NBA jerseys

    ReplyDelete
  12. I was suggested this blog by my cousin. I am not sure whether this post is
    written by him as nobody else know such detailed about my trouble.

    You are amazing! Thanks!

    ReplyDelete
  13. Hi to all, the contents existing at this website
    are actually amazing for people knowledge, well, keep up the good work fellows.cheap
    NFL jerseys

    ReplyDelete
  14. Thanks a bunch for sharing this with all of us you
    actually recognize what you're talking about!
    Bookmarked. Please also talk over with my site =).

    We could have a hyperlink trade contract among
    uscheap jerseys

    ReplyDelete
  15. Howdy I am so happy I found your webpage, I really found you by accident,
    while I was researching on Digg for something else, Nonetheless I am here now and would
    just like to say many thanks for a marvelous post and a all
    round interesting blog (I also love the theme/design), I
    don't have time to read it all at the minute but I have bookmarked it and also added in your RSS feeds, so when I have time I will be back to read
    more, Please do keep up the fantastic job.cheap MLB jerseys

    ReplyDelete
  16. Howdy very nice site!! Man .. Excellent .. Amazing .. I'll bookmark your blog and take the feeds
    additionally? I'm satisfied to find so many helpful information here in the publish, we need work out extra
    strategies in this regard, thanks for sharing. . . .
    . .cheap MLB jerseys

    ReplyDelete