Share via


Database Changes Detected Dialog Box

Appears if you attempt to save a database diagram or selected tables but some of the database objects that will be affected by the save action are out of date with the database. Accepting the changes shown in this dialog box updates the database to match your diagram and overwrites other users' changes.

Note

Although you cannot undo changes made to a table or database diagram, the changes are not saved to the database until you save the table or diagram. You can discard any unsaved changes by choosing No and closing all open diagrams without saving them.

Note

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.

  • Warn about difference detection
    Controls whether this dialog box appears next time you attempt to save a database diagram or selected tables. Checked means the dialog box continues to appear each time you save a diagram or table that is out of date with the database. Unchecked means the dialog box does not appear. By default, this box is checked. If you uncheck this option, you can recheck it in the Options dialog box.

  • Yes
    Updates the database with all the changes shown in the list.

  • No
    Cancels the save action.

    Note

    To refresh your diagram to match the database, close it without saving changes, right-click the diagram in Server Explorer and click Refresh, and then reopen the diagram.

  • Save Text File
    Displays the Save As dialog box, letting you specify a location for a text file containing a list of the database changes.

See Also

Tasks

How to: Reconcile a Database Diagram with a Modified Database

Concepts

Multiuser Environments