If you are facing a problem while saving any changes to a table in SQL Server with the error message
"Saving changes is not permitted. The changes you have made require the table to be dropped and re-created". It is not a problem in Sql Server 2005 Management Studio or Sql Server 2008 Management Studio but you need a little help in changing a few options.
Solution:
The solution is very simple. Follow the steps below:
Step 1: Click on Tools menu in SQL Server Management Studio
Step 2: Click Options
Step 3: When the option menu is displayed explore Designers on the left side of the window.
Step 4: Uncheck "Prevent saving changes that require table re-creation.
Step 5: Click OK
"Saving changes is not permitted. The changes you have made require the table to be dropped and re-created". It is not a problem in Sql Server 2005 Management Studio or Sql Server 2008 Management Studio but you need a little help in changing a few options.
Solution:
The solution is very simple. Follow the steps below:
Step 1: Click on Tools menu in SQL Server Management Studio
Step 2: Click Options
Step 3: When the option menu is displayed explore Designers on the left side of the window.
Step 4: Uncheck "Prevent saving changes that require table re-creation.
Step 5: Click OK
hmm it seem to be good
ReplyDeletetime saving tips.... its work
ReplyDelete