Appears when a new constraint has failed on existing data. Compare the ODBC error text that appears in the Save Incomplete dialog box with the two ODBC errors shown below to determine the appropriate solution.
[Microsoft][ODBC SQL Server Driver][SQL Server]The column [column name] in table Tmp_ [table name] may not be null.
A new database column has been added that doesn't allow null values and doesn't provide a default value. The table name in question appears after "Tmp_".
Change the column properties. Either select the Allow Nulls property or type a Default Value setting.
[Microsoft][ODBC SQL Server Driver][SQL Server]Attempt to insert the value NULL into column '[column name]', table '[database name] TMP_ [table name]'; column does not allow nulls. INSERT fails.
[Microsoft][ODBC SQL Server Driver][SQL Server]Command has been aborted.
The Allow Nulls property on an existing database column has been cleared, but the column has existing null values in it. The table name in question appears after "TMP_".
Go to the column and select the Allow Nulls property.
| How to edit column properties (Enterprise Manager) | Modifying Column Properties |
| How to set column properties using a database diagram (Enterprise Manager) |