Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Customer user experience program
Message
From
22/10/2013 16:43:34
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
22/10/2013 16:35:48
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01586014
Message ID:
01586164
Views:
17
>>The message says "Saving changes is not permitted.The changes you have made require the following tables to be dropped and re-created. You have either made the changesto a table that' can't be re-created or enabled the option Prevent saving changes that require the table to be re-created".
>>
>>All of which is wrong. Saving changes is generally permitted, not "not permitted" in general - a qualifier is missing. "Changes... require the table to be dropped" - wrong, changing from decimal(14,1) to decimal(14,2) does not. "You have made changes to a table that can't be re-created" - I've never seen such a table. _Every_ table can be re-created, just run the create script again. "...Or you have enabled the option..." - wrong, I never touched it, it's the default of a setting I never even knew existed.
>>
>>Permission to re-blog?
>
>Ah, I see. There is a lot of labeling here.
>
>The option I was referring to is "Tools\Options\Designers\Prevent saving changes that require table re-creation". But, you are probably aware of that.

Only vaguely. The very existence of such an option, specially after discovering that it may be wrong both ways (forbidding changes which don't require re-creation, or allowing those that do), made me wonder what other pieces of bad design are in there. And the help contains negative information - each time I tried to use it I ended up knowing less than before. So, Toad.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform