Home Dashboard Directory Help
Search

Change default "Prevent saving changes that require table re-creation" by Michael Freidgeim


Status: 

Closed
 as Won't Fix Help for as Won't Fix


6
1
Sign in
to vote
Type: Suggestion
ID: 432179
Opened: 4/13/2009 1:45:58 AM
Access Restriction: Public
3
Workaround(s)
view

Description

In Sql 2008 Management Studio table designer try to make a change to a table structure that requires the table to be recreated, the management tools will not allow you to save the changes and show not obvious dialog message.
See http://www.west-wind.com/weblog/posts/455560.aspx.
It will be good to change the default or add an option to change setting directly in this dialog.
Details
Sign in to post a comment.
Posted by Paulo Stradioti on 4/15/2013 at 10:06 AM
Or, as an alternative, the dialog could, at least, inform you where to make that change. The Usability of SMS is awful..
Posted by Cooperation on 12/18/2012 at 8:15 AM
+1 for a better explanation than a stock response of 'not right now'
Posted by TheDon Sansone on 6/7/2012 at 1:56 PM
See thread: https://connect.microsoft.com/SQLServer/feedback/details/352485/saving-changes-is-not-permitted

Go to Tools->Options menu. Under the Designers page, uncheck the option "Prevent saving changes that require table recreation".

This allowed me to change the table attributes inside SSMS
Posted by Microsoft on 5/12/2011 at 3:39 AM
Hi,

We took a look at this bug along with several others recently. Unfortunately, triaging it against other critical bugs, I do not think we would get to investigating this in the near future. However, we have taken note of this internally, and when we revisit this functionality in the future, we will try and get this resolved.

Thanks for writing in to Microsoft.

Regards,
Kamal
Posted by Jack Tripper on 6/25/2010 at 8:09 AM
Yes, having a "I don't care" checkbox (wording could be tweaked) would be nice. Or at least have a [Warning Icon] explaining that table change tracking (which i don't use) would lose history for the table (which i don't care about).
Posted by Michael Freidgeim on 5/7/2009 at 4:26 PM
It will be polite to explain why you Won't Fix?
Sign in to post a workaround.
Posted by Paulo Stradioti on 4/15/2013 at 10:07 AM
Sure, after you have made lots of changes you just discart them and use T-SQL. Not!
Posted by TheDon Sansone on 6/7/2012 at 1:56 PM
to Tools->Options menu. Under the Designers page, uncheck the option "Prevent saving changes that require table recreation".
Posted by Ivanzinho on 12/7/2011 at 7:25 AM
Just use T-SQL to alter the Table.