Galin Iliev's blog

Software Architecture & Development

SQL Server 2008 Management Studio – Saving changes is not permitted error.

I’ve been away from database side for a while but these days I am designing one. And I had a strange error while working in SQL Server Management Studio 2008. I made some changes and while trying to same the diagram I was shown this message:

“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 enable the option Prevent saving changes that require the table to be re-created.”


While message explains the issue well I couldn’t spot this option right away. So here is it: Tools->Options->Designers

Uncheck the box and that’s all..:


Hope this helps.

How to install the Windows Phone 7 Developer Tools on Windows Server 2008

Probably many of of you are like me – working on Windows Server (2008 R2) and wondering how to install the Windows Phone 7 Developer Tools on server OS. Luckily Aaron Stebner posted a solution on his blog:

There is a way you can work around the Windows Server 2008 setup block if needed.  Please note that this is not officially supported, so if you try these steps, you are doing so at your own risk.

  1. Download the Windows Phone Developer Tools web bootstrapper and save it to your hard drive
  2. Extract the contents of the setup package by running vm_web.exe /x and choosing a path to extract to
  3. Go to the folder you extracted to in step 2 and open the file baseline.dat in notepad
  4. Look for the section named [gencomp7788]
    Note - you have to change this exact section - this is the one that controls the OS version blocking behavior in Windows Phone Developer Tools setup.
  5. Change the value InstallOnLHS from 1 to 0
  6. Change the value InstallOnWin7Server from 1 to 0
  7. Save and close baseline.dat
  8. Run setup.exe /web from the folder you extracted to in step 2
    Note - please make sure that you include the /web command line parameter in step 8.  If you don't, setup will not attempt to download the packages it needs to install, and it will fail to install correctly as a result.

Neat… Thanks Aaron!