• Note that

    insert into TableName default values

    should not be confused with

    insert into TableName (columnName) values(default)

    The latter of which is not valid for an identity column.