User cancelled out of save dialogue (MS Visual Database Tools)

Little scum · Posted on 6/13/2016 4:21:29 PM

The first dialog warns about the fact that the changes made cannot be saved because they require the table to be re-created. This behavior is by default and happens under the following conditions:

TITLE: Microsoft SQL Server Management Studio
------------------------------

User cancelled out of save dialogue
(MS Visual Database Tools)

------------------------------
BUTTONS:

OK
------------------------------

- Adding a new column to the middle of the table
- Dropping a column
- Changing column nullability
- Changing the order of the columns
- Changing the data type of a column

Solution.

To change this behavior and let the designer made the changes for you, please do the following:

- On SSMS click on the Tools menu, then click Options.
- Click on Designers
- Clear the "Prevent saving changes that require table re-creation" check box.

Gu Yan said · Posted on 6/14/2016 6:23:07 PM

[Source] User cancelled out of save dialogue (MS Visual Database Tools)

Related Posts

Sections viewed