Friday, August 22, 2008

SQL 2008 Open Table is gone

Another change that wasn't obvious at first is that the Open Table option is gone when a table is right clicked. I'm sure that was probably ambiguous so MS had to take it out.

The Open Table command has now been replaced with Edit Top 200 Rows.

Well what if there is a row at 201 that I want to edit. Is there no easy way to right click and just open all the rows.

29 comments:

Chris Clark said...

i like this feature. i find myself carelessly hitting open table on enourmous tables in 2005 all the time and wasting a ton of cycles and time. if im editing a larger table its a lot easier to write a query anyway than to visually scan a ton of rows.

Anonymous said...

Well, I don't. I commonly need to edit table entries and would like the option to see all the records.

Anonymous said...

I like the open table as well.

Do get around it
Right Click->Eidt Top 200 Rows
When the table comes up click the 'Show SQL Pane'
Remove the 'Top 200' part of the query then execute.

Not too bad a work around.

Charcoal Moon said...

It amazes me that we need a "work around" when going from 2005 to 2008. I think it is stupid to remove Open Table. The improvement should have been to leave Open Table but also add the Top 200 Rows.

romabr said...

Then the right click menu will grow up and will be not user friendly. Therefore I think that will be greate to remove Select top 1000 rows option. If we have edit, so why we need select option?
(open table is a bad option when you try it on large table with 500.000 rows)

Jason Bean said...

As with other options, configurable settings would have been the best solution. Provide the opportunity for a user to specify if they want all rows returned or a subset, which would also be defined by a user.

Dalamar said...

Hi.
you can edit the setting
http://bradmarsh.net/index.php/2008/04/21/sql-2008-change-edit-top-200-rows/

Thanks

Anonymous said...

That worked!! Thanks!

Anonymous said...

It's replaced by "Edit Top 200 Rows". You can change that command in the Tools > Options > SQL Server Object Explorer > Commands. Changed the value in options to 0 and you can open the entire table.

They did this because people were accidentally opening huge tables with the old Open Table command.

Anonymous said...

stark fibronectin debilitates shekhar mode neilsen draws chive borders aerospace elaboration
servimundos melifermuly

Anonymous said...

thnx all

Anonymous said...

thnx all

Anonymous said...

Obvіouѕly, you'll be able to go to sites as You - Tube at which you might locate lots of funny vids. Perhaps the best thing to do is keep an eye on the promotional deals and be ready to pounce quickly when a suitable one comes up. This not only allows listeners to listen to their favorite MP3 files along with their SIRIUS radio; it also lets them digitally record their favorite radio songs for instant playback.

Feel free to surf to my web page: mouse click the up coming post

Anonymous said...

I am not sure ωhere you arе gеtting уour info, but good topic.
I needѕ tο spend some time learning muсh more оr understanding
more. Thаnks for magnificent info I wаs looκing fοr this information for my miѕsіon.


Heгe is my sіtе youtube videos downloaden

Anonymous said...

Yоu can also buy bunԁle deals, ωhich
most гаԁio stationѕ оffеr, to decreaѕe the ovеrall ad coѕt.
Mаnу ρеople will be hаpрy
with гeρlacеable batterieѕ for home use аnd
οсcаsional outings. A ΜOΒILΕ
APP GӀVES ΤHE STAΤӀΟN A DIRECT MARKETING
CHANNEL TO СΟMΜUNӀCATE WITΗ
THEΙR LIЅTENERS.

Feel free tο surf to my web-ѕite; click through the up coming webpage

Anonymous said...

Hi there, I enjoy reading all of your article. I like to write a little
comment to support you.

Feel free to visit my site; click through the next page

Anonymous said...

Each listing includes the skills taught and the suggested age for
the activity. Real game, real people, real thrill and of course real
money; is all about online gaming, the perfect place to fulfill your desire to be
a multi millionaire. Even when things seem hopeless, Kiko's narration provides some great comedy relief.

Feel free to surf to my blog post - http://www.nudeinlove.com

Anonymous said...

Then a splash screen that is not present on the purchased version "nags" for
several seconds, and the background from the desktop is displayed on the laptop.
Thus professional firms for web development in London are better got in touch
with. In essence, they appreciated each other and never lost sight
of how lucky they felt to have each other as their spouse.
As a rule of thumb, if an app has been successful in i - OS or Android format, it is likely to also be found on Windows Marketplace.
Do you really want to see the hard-earned money of
you and your spouse end up in the bank account of a lawyer
who doesn't even know you. Those pain killers and medications hide the problem without dealing with the true cause. Of course, many people looking to boost their bone health choose to supplement their diets. Nevertheless, we're now moving on and
talking about the top Xbox 360 games for 2012. Do you want a
top notch gaming PC that can play all the latest games at max
or near max settings. So be it.

Also visit my website - Dead space 3 Key

Anonymous said...

Some people have hormonal disorders, glandular conditions, genetic conditions or other concerns that are beyond their control that makes it harder
for them to lose weight. People can control their blood sugar levels regularly according
madhunashini Vati. Ein weiterer Inhaltstoff ist nach wissenschaftlichen Arbeitsverfahren das 100% natürliche „Garcinia Cambogia" (HCA).

Feel free to visit my web-site: Www.5-10kgabnehmen.d...
My page > Www.5-10Kgabnehmen.De

Anonymous said...

I didn't want to drive all the way back to Autozone to pick up a new terminal post clamp, so I figured I'd attach it and see what
happened. As you lift out the screen you'll see it is still attached via a ribbon cable. Both Intel and AMD contain information built in the processor to allow the processor to be used efficiently with mobile computing saving on battery life while giving the best performance.

Feel free to surf to my blog post - onlineradio

Anonymous said...

At times the selection may be off, you can
always dislike a song meaning that it will never appear on your radio again.
You will get an account and once you get yourself registered with Odyssey Streaming.
The key is to have a clear understanding of the market
so the money spent on broadcast advertising isn't wasted.

My web page; Highly recommended Internet site

Anonymous said...

But these people are few and far between and can provide a
false of security. Make it worth your while when listing items and pricing.
Unlike pawn shops, these diamond buyers actually have a reputation to protect and therefore will do their best to provide you with
the best cash settlement possible.

Feel free to surf to my web blog; musiciansfriend Com

Anonymous said...

This application solves one of the major issues with the i - Phone cameras photo output - light issues.

Many communities hold Earth Day celebrations that offer members of the community to
participate in activities to benefit the neighborhood and also fun activities for children and adults.

The reflections of the sky, not only in the water, but on the boat as well, lend a hand to a desired blending of color and a balance that is perfection.



Also visit my web-site; Beauty

Anonymous said...

I'm not sure where you are getting your information, but
great topic. I needs to spend some time learning more or understanding more.
Thanks for wonderful info I was looking for this information for my mission.

Feel free to surf to my blog post; lock services

Anonymous said...

Created popular well before her slippers and Dorothy, rubies have been a classic favorite.
The certified official can't grab stock in business of the company.
Use TinyUmbrella to backup your SHSH blobs.

my web blog - jailbreak iOS 7.1.1 ()

Anonymous said...

Every weekend i used to go to see this web site, because i want enjoyment, since this this web page conations actually
good funny information too.

Feel free to surf to my homepage ... www

Anonymous said...

Howdy! This is kind of off topic but I need some help from an established blog.

Is it very hard to set up your own blog? I'm not very techincal but I can figure
things out pretty quick. I'm thinking about setting up my own but
I'm not sure where to begin. Do you have any points or suggestions?
Many thanks

Also visit my blog; Garcinia Cambogia HCA

Anonymous said...

Thanks for finally talking about > "SQL 2008 Open Table is gone" < Loved it!

Check out my website: Slim Garcinia Premium

Anonymous said...

best e cigarette, electronic cigarette, vapor cigarette, smokeless cigarettes, e cig reviews, smokeless cigarettes