Saving Changes Is Not Permitted (SQL Server 2008 R2)

Pada saat akan memanjangkan length pada suatu field, lalu muncul error seperti ini "Saving changes is not permitted. The change 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."

Error diatas terjadi karena konfigurasi dari sql servernya, maka cara mengatasinya adalah dengan cara klik Tool -> Options.

Lalu klik Designer uncheck tabel options "Prevent saving changes that require table re-creation".

Ulangi perubahan kemudian save.