Page 1 of 1

MSSQL INSERT where there is a TIMESTAMP column

PostPosted: Fri Oct 10, 2014 7:10 pm
by kanderson_iss
Hi!

I've ran into a problem that I've not been able to find a solution for, here or elsewhere.

I am using DBeaver 3.0.1 on Windows 7 64-bit.

The database is MSSQL Server 2008 R2.

Almost all the tables have a timestamp column (SQL Server datatype of timestamp). In SQL Server, timestamp columns cannot be inserted or updated.

If I attempt to add a new record to a table, using the grid in DBeaver, I get an error on the timestamp column. Even if I filter out the column, it still errors.

Is there a solution for this?

Cheers!


Kevin