Msg 1755, Level 16, State 0, Line 1
Defaults cannot be created on columns of data type timestamp. Table ‘%.*ls’, column ‘%.*ls’.
This error message appears when you try to create a DEFAULT constraint for a column of the type timestamp.
The T-SQL statement can be parsed, but causes the error at runtime.
Error of the Severity level 16 are generated by the user and can be fixed by the SQL Server user. You must remove the DEFAULT constraint statement.
All versions of SQL Server.
CREATE TABLE #t
t1 TIMESTAMP NOT NULL DEFAULT 0
TIMESTAMP values are automatically generated and assigned by SQL Server. The specification of a DEFAULT constrain for a column of this data type is unnecessary and therefore not allowed.