Fixing Save is not permitted in SQL Server 2008


April 14, 2009
There is no reason we shouldn't share our knowledge and experience. Please send me an article about IT, I will post it on my website, sure with a link back to your website. [More]

another tip »

When you try to save a table when you change a column in SQL Server 2008, you will received: “Saving changes is not permitted. The changes you have made require the following tables to be dropped and recreated. 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-create.

Save is not permitted Sql2008

Save is not permitted Sql2008


To fix the problem, go into:Tools -> Options -> Designers and uncheck “Prevent saving changes that require table re-creation”.

Share
Under Category: SQL Code
Article Tags: ,
March 7th, 2010

thanks that really helped me. i was stuck updating my medellin apartments database.

April 12th, 2011

takes some Greek amorous feelings of the flat sandals quietly into the line of sight of people.

April 25th, 2011

BURBERRY Prorsum2010 chun xia series dust coat said Hamlet, survival or destruction? This is a question. And now, for fashion observers and fashion critics speaking, fashion trend of life and death has become a problem.

Trackbacks
Leave a Reply