Database Changes Detected Dialog Box (Database Designer)

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 database diagram. You can discard any unsaved changes by choosing No and closing all open database diagrams without saving them.

Yes

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

No

Cancels the save action.

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.

For more information about saving database objects that have changed since you began working in the Database Designer, see Reconcile a Database Diagram with a Modified Database and Interactions Between Database Diagrams, Table Design Windows, and the Database.