Study Material For Job Assistance Headline Animator

Sunday, November 20, 2011

Saving changes is not permitted in Sql Server 2008

Saving changes is not permitted in Sql Server 2008

Saving changes not permitted. The Changes you have made require the following tables to be dropeed. On Save of table object Error Save (Not Permitted) Dialog Box in Sql Server 2008

When we are using sqlserver 2008 earlier days of our experience you will get this issue often on doing bellow changes for a table
  • Adding a new column to the middle of the table
  • Dropping a column
  • Changing column nullability
  • Changing the order of the columns
  • Changing the data type of a column
The error like bellow
 
1. Error we get when try to do any operations on table
We can resolve this irritate message, where in this option is not selected by us. this default selection of management studio
To resolve this issue go to Sqlserver Management Studio>Tools>Options>Expand Designers>Click on Table and Database designers> Uncheck "Prevent Saving changes that requires table re-creation" like bellow
2.By following this above we can resolve this issue
    after doing successfully now try to change table. it will resolve.

No comments:

Post a Comment