Guy Barrette, Microsoft, Regional Director, Montreal, Canada, Visual Studio, .NET Expertise SQL Management Studio – Saving changes is not permitted - Guy Barrette

Guy Barrette

Microsoft Regional Director, Montreal, Canada

SQL Management Studio – Saving changes is not permitted

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.

TableCreation1

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”.

TableCreation2

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

Bookmark and Share
Posted: Aug 26 2009, 08:36 AM by guybarrette | with 4 comment(s)
Filed under:

Comments

Rachit said:

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

# August 27, 2009 9:34 AM

BP said:

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

# June 19, 2010 3:34 PM

paradis said:

hi, check “Prevent saving changes that require table re-creation”

But do not save. why??

# June 9, 2011 5:20 AM

Gian said:

thanks mate it total solve my Editing of tables. :)

# July 6, 2011 10:34 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)