Sunday 25 January 2009

Turn Off - Prevent saving changes in SQL Server 2008

I was working with SQL Server 2008 for quite some time and noticed a strange behavior (which is not in previous versions of SQL Server) when I try to save a table in Management Studio that requires table to be dropped and recreated (e.g. Try to ADD a new NOT NULL column to the table which is having data) .I get the following warning message


Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.


I though it is bug with SQL Server, but later cam to know it is the expected behavior and can be turned of by unchecking "Prevent saving changes that require table re-creation" in the Designer properties. Please refer to the below screen shot


5 comments:

Anonymous said...

You could сегtainly see уоuг skills іn the аrticle you writе.
The аrena hopеs for evеn moгe pаsѕionate writeгs ѕuсh аs you ωho aгen't afraid to mention how they believe. At all times go after your heart.

Also visit my web-site ... référencement naturel

Unknown said...

ninest123 16.03
ray ban sunglasses, cheap oakley sunglasses, replica watches, michael kors outlet, oakley sunglasses, jordan shoes, prada handbags, nike outlet, nike air max, nike free, louis vuitton, tiffany and co, ugg boots, louboutin outlet, ray ban sunglasses, louis vuitton outlet, burberry outlet online, michael kors outlet, chanel handbags, uggs on sale, tiffany jewelry, louis vuitton outlet, michael kors outlet, oakley sunglasses, oakley sunglasses, louboutin shoes, prada outlet, ugg boots, ray ban sunglasses, ugg boots, burberry, replica watches, michael kors outlet, tory burch outlet, longchamp outlet, michael kors outlet, louis vuitton, michael kors, polo ralph lauren outlet, longchamp outlet, louis vuitton, polo ralph lauren outlet, louboutin, oakley sunglasses, gucci outlet, ugg boots, christian louboutin outlet, nike air max, longchamp

Unknown said...

ugg,uggs,uggs canada, canada goose, ugg,ugg australia,ugg italia, canada goose, hollister, wedding dresses, moncler, louis vuitton, canada goose outlet, swarovski, pandora charms, pandora jewelry, moncler outlet, moncler, sac louis vuitton pas cher, replica watches, louis vuitton, marc jacobs, louis vuitton, vans, moncler, swarovski crystal, pandora jewelry, toms shoes, moncler, juicy couture outlet, doudoune canada goose, karen millen, converse, lancel, canada goose outlet, coach outlet, gucci, ray ban, thomas sabo, moncler, supra shoes, canada goose uk, juicy couture outlet, links of london, barbour jackets, louis vuitton, canada goose, barbour, ugg boots uk, pandora charms, bottes ugg, converse outlet, moncler, montre pas cher, canada goose, ugg pas cher, moncler
ninest123 16.03

chenlina said...

chenlina20160531
oakley sunglasses
oakley sunglasses outlet
coach factory outlet
louis vuitton outlet
true religion jeans
lebron 13
adidas nmd
louboutin pas cher
replica watches
hollister outlet
tiffany and co
hollister clothing
cheap ray ban sunglasses
ray ban sunglasses
michael kors handbags
coach outlet clearance
louis vuitton purses
michael kors outlet
jordan concords
nike roshe flyknit
coach factory outlet
louis vuitton handbags
coach factory outlet
air jordan 13
coach outlet online
michael kors uk
louis vuitton handbags
fitflops sale clearance
fitflop sandals
gucci handbags
louis vuitton outlet
polo ralph lauren
burberry bags
kobe 10
michael kors uk
nike store
abercrombie and fitch new york
air jordans
ray ban sunglasses
michael kors
as

yanmaneee said...

jordan 12
mbt
ferragamo belt
yeezy boost 350
christian louboutin outlet
yeezy boost 350 v2
balenciaga triple s
supreme hoodie
off white
balenciaga