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 |
|
shershah
Starting Member
2 Posts |
 Posted - 2009-05-03 : 02:43:53
|
| i have a proble with all tables into database when i try to modify a table structure using design view it show following error messagesaving is not permitted. the changes you have maderequired the following tables to be dropped and re-created. you have either made changes to a table that can't be re-created or enable the option prevant saving changes that requir the table to re-created.how can i modify table structure without any lose of data. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-05-05 : 05:54:28
|
| Go to Tools -> Options - then click on Designers -> Table and Database Designers and untick the box that says Prevent saving Changes that require table re-creation. |
 |
|
|
|
|
|
problem when modify table