We have recently upgraded from version 12 to 17, currently running 126.96.36.1990.
I have a routine that uses dbtran.exe to translate a transaction log file to SQL, then (roughly) greps out the 'connect' comments that are included in the SQL and extracts the date the connection was made from part of the comment string.
In version 12 these comments were of the form:
but in version 17 the year of 2016 is actually written as 3616:
it's also interesting that version 17 writes 'COMMIT' comments in a similar format but in this case the year is written as 2016:
Is this expected behaviour? If so can I simply take 1600 off the year from the comment to get the actual year or is the calculation dependent on some other variable?
This is a bug that was introduced as a side effect to the changes made for the Point-In-Time Recovery feature that was added in v17. For now, you can just subtract 1600 from the year in the dbtran output, and a fix is forthcoming in the near future (which is slightly more complicated than simply subtracting 1600 unfortunetly).
[Edit: Sept 27, 2016] The aforementioned near future has arrive. This issue should be resolved in v17 build 2176.