skip to main |
skip to sidebar
Saving changes is not Permitted. The Changes you have made require the following tables to be dropped or 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 table to be re-created.
This is an annoying message that is prompted when trying to make changes to a table in SQL Server 2008/Express. While there can be many valid reasons for having this option [Prevent saving changes] switched on by default you would prefer to have this switched off during the implementation phase of the project.
Steps to disable the option [Prevent saving changes]
- Click on the Tools menu
- Click on Options of the Management Studio
- Click on the “Designers” tree
- Click on “Table and Database Designers”
- Uncheck “Prevent saving changes that require table-creation”
- Click “Ok”
When i was trying to execute a WCF application created using a previos version of Windows (XP) came across the following error.
HTTP could not register URL http://+:8000/. Your process does not have access rights to this namespace (see http://go.microsoft.com/fwlink/?LinkId=70353 for details)
You can expect this error when trying to run a WCF service with an HTTP binding on windows VISTA. As you may have already noticed the culprit is the new Vista security settings. Usually the Visual Studio runs under the logged in user account which may not have sufficient priviledges to listen at a particular http address.
Find the solution here - http://blogs.msdn.com/amitlale/archive/2007/01/29/addressaccessdeniedexception-cause-and-solution.aspxOnething missing in the solutions was how to run the command prompt as the administrator.Type "command Prompt" - in the start search box, then the command prompt would appear in the search results list, right click an say run as administrator. But you can avoid all this hassel by running the VS studio as the administrator. :o) have fun!!
