MsSql Server Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

Sql Server Managament Studio içerisinden
Tools => Options Menüsüne girelim. Açılan pencerede Designer menüsüne Sonra da altındaki Table And Database Designer alt Menüsüne Tıklayalım. Gelen Seçeneklerden "prevent saving changes that require table re-creation" checkbox  kutusunda ki işareti kaldıralım. Sorunumuz çözülmüştür.



Tools => Options=>Designer=>Table And Database Designer=>

prevent saving changes that require table re-creation  (unselect) 






Saving changes is not permitted. The changes 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 tables to be re-created.