MS-SQL @@DBTS

[#1]

Dear Community,

on MS-SQL-Server the TimeStamp is not realy a "Time Stamp". For further information watch this:

http://msdn.microsoft.com/en-us/library/ms182776(v=SQL.90).aspx

For a clean incremental load, i want get the actual latest ROWVERSION from the SQL-Database using @@DBTS.

Is there an easy way to use this statement directly in the script ?

Thanks in advance for any help.

Christian

[#2 · Accepted solution]

Dear Community,

it's solved. The command "Select @@DBTS" returns without a fieldname. "Select @@DBTS as LastRowVersion" works.

Geetings