Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sven2
Yak Posting Veteran
57 Posts |
 Posted - 2010-07-19 : 04:18:18
|
| Hello,since last week i can't make any changes to my tables. I can do so when I unclick the parameter:prevent saving changes that require table re-creation.When I unclick this parameter and save the table can I loose data?Why do I need to unclick this parameter now?Thanks in advance,Sven. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-07-19 : 04:54:49
|
It depends on the changes that you have made or want to make.For example if you want to change an ID column to identity then there is a need to re-create the table becaue without it isn't possible to make a column to identity.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-07-19 : 04:57:19
|
| This is a feature of SQL 2008. Microsoft trying to be helpful and ensure you know what you are doing before dropping or editing tables. If you know what you are doing, just turn the feature off, but please ensure you know when you are likely to have data loss due to editing a table (such as doing a drop/create rather than an alter. |
|
|
|
|
|
|
Can't save tablechanges