Prompt when modifying SQL Server tables: Saving changes is not permissted. The changes you has made require the following tables to be dropped and re-created ...

problem: when modifying the database table, can not choose to save, prompt: Saving changes is not permitted, such as 1, if you choose Cancle, will be revoked save, if you choose Save Text file, will save a txt files, But not SQL script, personally feel useless.

Workaround: Do not catch the urgency, this is because you set the save changes when rebuilding the table (which is usually the default)

1. Go back to the SQL Server home page.

2. Select tools-->options-->designers-->table and Database designers, remove prevent saving changes that require Table re- Creation.

Prompt when modifying SQL Server tables: Saving changes is not permissted. The changes you has made require the following tables to be dropped and re-created ...