Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Database Changes Detected Dialog Box (Visual Database Tools)

This dialog 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 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.

Warn about difference detection

Specify whether this dialog box appears the next time you attempt to save a database diagram or selected tables. Checked means that the dialog box continues to appear each time you save a diagram or table that is out of date with the database. Unchecked means that 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

Update the database with all the changes shown in the list.

No

Cancel the save action.

Note 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

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.