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
 General SQL Server Forums
 New to SQL Server Programming
 Saving Chagne not permited

Author  Topic 

twnzus
Starting Member

1 Post

Posted - 2009-07-20 : 12:20:45
Hi I am new to SQL Server Express.

I have created some DB tables via SQL server Management Studio. One of the probelm I keeping on having is whenever I try to create a table a error message pops up with the following message.

"saving change is not permited. The change you have made require the following table to be droped or recreated. You have either made changes to a table that can't be recreated or enabled the option Prevent saving changes that require tables to be re-created."

would really appreciate if someone could enlighten me what steps I can take to enable save change.

thanks a million

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-07-20 : 14:15:09
You can uncheck this option in Tools -> Options menu.



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page
   

- Advertisement -