Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Saving changes is not permitted. The changes you h

Author  Topic 

blocker
Yak Posting Veteran

89 Posts

Posted - 2010-01-07 : 01:09:54
Ive got this problem when i switch to sql server 2008 from sql server express 2005. Ive attached my 2005 sql database(qbsqlserver.mdf) to sql 2008 but when i change something on the table in design mode like changing the data types, Ive got an error below:

"Saving changes is not permitted. The changes you have made require the followilg tables to be dropped and re-created. You have either made changes to a table that can't be recreated or enables the option Prevent Saving Changes that require the table to be re-created."

I cant figure out this error until now and im still suck on this..

Thank you.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-07 : 01:25:22
http://support.microsoft.com/default.aspx/kb/956176
Go to Top of Page

blocker
Yak Posting Veteran

89 Posts

Posted - 2010-01-07 : 01:37:45
thank you for the helpful link. It solves the problem..

God bless
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-07 : 01:39:13
great
Go to Top of Page
   

- Advertisement -