Blog
.NET
ajaxcontroltoolkit
Best Practices
Blog
business tip
c#
Categories
comments
css
Database
email
Excel
flickr
GoDaddy
Google Analytics
Google Webmaster Tools
Hosting
IIS
Kentico CMS
linq
minne*
minnebar
MS SQL
MSSQL
MVC
MySQL
networking
peripheral
Rackspace Cloud
robots.txt
RSS
scripts
seo
service
sitemap.xml
Social Networking
tags
Title
trackbacks
training
twitter
Vista
Visual Studio
WordPress
xhtml
SQL Server 2008 – Saving Changes is not permitted.
November 19, 2009 Author: Joel
When trying to save a table when inserting a new column other than at the end I ran into this error:
Saving changes is not permitted. The changes 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 enabled the option Prevent saving changes that require the table to be re-created.
Solution:
In Management Studio, Tools –> Options then go to the Designer Page and uncheck “Prevent saving changes that require table re-creation”.
Solution found at: http://pragmaticworks.com/community/blogs/brianknight/archive/2008/06/04/sql-server-2008-designer-behavior-change-saving-changes-not-permitted.aspx
-
Categories
- asp.net (12)
- Blog (3)
- Business (5)
- Conferences (1)
- Errors (5)
- Office (1)
- Portfolio (3)
- Reviews (3)
- SEO (4)
- SQL Server (4)
- Tips (2)
- Uncategorized (2)
- Web Development (14)
-
Archives