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 |
|
Nodrog
Starting Member
2 Posts |
 Posted - 2012-12-13 : 12:27:42
|
| When trying to modify a column data type in a 3rd party database, I get a message stating that "Saving changes is not permitted" and that tables would have to be dropped or recreated. Is there a prevent option or something I need to change? |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-12-13 : 12:36:07
|
| I would be weary about changing it if it is a vendor database - might void your warranty or break their code or middle tier applications.However, if you do want to do it, Tools->Options->Designers->Table and Database Designers and uncheck the "Prevent saving changes that require table recreation". |
 |
|
|
Nodrog
Starting Member
2 Posts |
Posted - 2012-12-13 : 12:45:19
|
| Great, thank you very much, that was the problem |
|
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2012-12-18 : 03:52:51
|
| Wow, that's a good one |
|
|
|
ScottPletcher
Aged Yak Warrior
550 Posts |
Posted - 2012-12-21 : 17:53:08
|
| Whenver possible, you should use an ALTER TABLEstatement instead of changing the table thru SSMS "Design". SSMS is not only much more overhead, but it can sometimes "hang" and/or cause strange errors. |
|
|
|
|
|
|
Can't modify column data type