"None can stop the rising sun, clouds can hide for a while........" -Ravi

Sunday, February 8, 2009

Save not permitted in SQL Server 2008 Express Management Studio

I got the following message, When I was trying to change or add new columns for tables in SQL Server 2008 Express.

Message: " Save not Permitted. The changes you have made require the following tables need to dropped and re-created. you have either made changes to a table that can't be re-created or enabled the option preventing saving changes that require table to b re-created."

The only choice I had was to click to cancel, or to choose to save the message to a text file. Which won't useful to us. I found the answer for this bug in SQL Online. here it is..


Go to Tools -> Options -> Designers -> Uncheck "Prevent saving changes that requires table re-creation"

I hope it works for you also...

1 comment:

Anonymous said...

thank you - this was bothering me for a while now.