Topic: How to copy value in the field timestamp

There is a problem. After check CHECKDB showed that the table is damaged, treatment repair_allow_data_loss is recommended.
, the table is found. Created , I want to overtake the data in it.
But produces an error -
Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.

Esteemed "" how much understood it is impossible  this value, truly? How to be in such situation?


Re: How to copy value in the field timestamp

timestamp do not copy, it is the auxiliary column


Re: How to copy value in the field timestamp

If at you  happens similar problems in an index, try to rebuild simply all indexes in this table after that checkdb will probably not produce an error.


Re: How to copy value in the field timestamp

indexes, deleted,  - did not help.
Msg 8914, Level 16, State 1, Line 3
Incorrect PFS free space information for page (1:367433) in object ID 1071342881, index ID 1, partition ID 72057851248050176, alloc unit ID 72057594137870336 (type LOB data). Expected value 0_PCT_FULL, actual value 100_PCT_FULL.
DBCC results for ' _Document371 _ '.
There are 15 rows in 1 pages for object "_Document371 _".
CHECKTABLE found 0 allocation errors and 5 consistency errors in table ' _Document371 _ ' (object ID 1071342881).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (BayaderaLogJitomir.dbo. _ Document371 _).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.