Failed to compress the database: The column cannot be modified because it is either a computed column or is the result of a UNION operator

Error Message

When trying to compress a SQL Server database, the following error may be returned:

"Failed to compress the database:
Underlying DBMS error [[Microsoft][SQL Server Native Client 11.0][SQL Server]The column cannot be modified because it is either a computed column or is the result of a UNION operator.]"

Cause

SQL Server database tables that contain computed columns cannot be compressed because the geodatabase does not support auto-populated fields such as computed columns or auto-incrementing fields.

Solution or Workaround