Pablo Peralta's Blog

Good One! Worked. Thank you

Great!. Thanks.

I try to fixed it very long times.Thanks a lot. ^_^

Thanks worked out well.  I'm still learning SQL so am grateful when finding time savers like this.

Thanks alot!

That's silly. "Unhandy by design" ?

When I'm designing tables, most of the time they'll still be _empty_ anyway, so what do I care if they need to be dropped and rebuilt...

Same people who designed Vista obviously worked on SQL 2008

What a bunch of idiots, by default we don't let you modify a table after it has been created, MUPPETS!!

Thanks a lot. Now i am able to do the chages in the table poperties uisng  management studio.

Wow now even in SQL 2008 they make these silly "we know what's best for you" decisions. I fear in SQL2010 MS Bob will reappear. MSFT what's wrong with you lately ?

I think this is a GOOD thing, as you wouldn't want to drop a table in a production db by accident.  My nit is that SSMS tries to drop the table even if I simply add a new column to the table.

Thanks a lot!!!

отлично написано, у автора прям талант

THANKS!!

I just ran into this and did not want to re-create my table manually. You are a lifesaver.

******************

Jonshan

<a href="http://www.bondsavings.info"rel="dofollow">Top Savings Accounts Savings Accounts</a>

nice and thanks.

Thank you so much!)

Yes !!!! many thanks mister ^^

Thanks for a very good and simple solution

Thanks - you saved me a lot of work!

Thank you very much

thanks good solution. i am trying to save i found your way

Thanks alot, I was bout to pull out my hair. Such an easy fix, IF you know what button to Push.

Thanks,

Earl

If you use this option, SQL might just wipe out all the existing data in your table. That happened to me when I added a datetime field set to 'no nulls' to an existing table. It did not give me a warning about what it was going to do either.

thanks a ton. worked for me

thanks . its working

Thanks for the tip!

Thanks.

Crazy thing to have check marked out of the box without notifying DBA's or Developers...

Thanks for being there.

Thanks!

Great! it's work, thank you very much!!!

Great Work man

Great ! It's work. thanx....

this helped.thanks

this hint should be in the error message ...

thanks!!!!

Thank you.

Really timely help great pakka

Smart help, Thanks A lot

Cheers for this - just saved me a load of time

Tank

Many thanks

I feel dumb for not knowing this.  Thanks!  You saved me from myself!

More stupid default behaviour from MS to remove! Thanks for a great find :)

Thanks a lot. you saved my time.

Tks so much!

Thaks a lot,

Your post helped me solve my issue. Thanks