Problem with timestamp by copying data

lape

Hi,
i want to create a copy of table data via sql. But I have a problem when I want to insert the data in another table.
I tried
INSERT INTO table2 (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM table1
WHERE condition;

ma7eoo

Hi,
What error message do you get?

Slawek_Guzek

Skip the timestamp column in your INSERT and SELECT column lists.

The timestamp column is maintained automatically by the SQL Server, its value cannot be specified in any INSERT/UPDATE query