Validation Warnings Dialog Box

Appears if you attempt to save modifications with potentially damaging side effects— or if the database commit operation is likely to fail. This dialog box indicates what those side effects might be or why the commit operation might fail. It gives you the chance to proceed with the modification or cancel the operation.

Note   This dialog box appears when you attempt to transmit your modifications to the database.

The dialog box can appear for any of these reasons:

• You might not have database permissions to commit all the modifications.
• Your modifications would result in improperly formed derived columns, default constraints, or check constraints.
• A modification to a column’s data type might cause data loss.
• A modification would result in an index greater than 900 bytes.
• A modification would change a table or column contributing to a schema-bound view or user-defined function.
• A modification would result in the re-creation of a table that has one or more encrypted triggers; the triggers will be dropped.
• Your modifications will yield noteworthy settings of ANSI_NULLS or ANSI_PADDING or both for the columns within one table.

Yes

Proceeds with the operation. That is, selecting Yes proceeds to generate the change script or transmit the modifications to the database. Remember, even if you are transmitting the modifications to the database and you select Yes, the commit operation could still fail if you do not have privileges to modify the database; if your modifications would result in an index greater than 900 bytes; or if your modifications would result in an improperly formed computed column, default constraint, or check constraint.

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 warnings.