ASA Database Administration Guide
Database Options
Alphabetical list of options
Controls interpretation of new columns with the TIMESTAMP data type.
ON, OFF
OFF
Controls whether any new columns with the TIMESTAMP data type that do not have an explicit default value defined are given a default value of the Transact-SQL timestamp value as a default. The AUTOMATIC_TIMESTAMP option is included for Transact-SQL compatibility. The default is OFF.
For more information, see Setting options for Transact-SQL compatibility.