Attention: We are retiring the ASP.NET Community Blogs. Learn more >

SQL Management Studio – Saving changes is not permitted

Wednesday, August 26, 2009

.NET

If you want to change the structure of a table, by default SQL Management Studio prevents you from doing this if it require that the table be dropped and recreated.

If you want to change this behaviour, from the Designers section in the Tools/Options menu, simply uncheck “Prevent saving changes that require table re-creation”.

http://msdn.microsoft.com/en-us/library/bb895146.aspx

4 Comments

Thanks Guy! I didn't know how to fix this annoying message when you make a change in the SQL Diagram window.

Rachit - Thursday, August 27, 2009 1:34:21 PM
Thanks so much, I thought that it was my hosting company telling me I don't have rights to edit a table to NOT NULL.... thanks again

BP - Saturday, June 19, 2010 7:34:37 PM
hi, check “Prevent saving changes that require table re-creation”
But do not save. why??

paradis - Thursday, June 9, 2011 9:20:02 AM
thanks mate it total solve my Editing of tables. :)

Gian - Thursday, July 7, 2011 2:34:16 AM

Comments have been disabled for this content.