Friday, 3 August 2012

SSMS: Prevent saving changes that require table re-creation

Case
When changing a column in a table I get this message preventing me to save the changes:
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-created.


























This question got nothing to do with SSIS self, but editing tables is a common task for SSIS developers. And I'm always browsing a couple of minutes to find the right option to disable.


Solution
1) Menu Tools
Go to the Tools menu and select "Options..."
Tools


















2) Options, Designers
Go to Designers and disable Prevent saving changes that require table re-creation.
Designers

1 comment:

  1. Thanks for the helping me find where this option was.

    ReplyDelete

Please use the SSIS MSDN forum for general SSIS questions that are not about this post. I'm a regular reader of that forum and will gladly answer those questions over there.

All comments are moderated manually to prevent spam.

Related Posts Plugin for WordPress, Blogger...