Options
DATETIME2 precision issues
![msnelling](https://us.v-cdn.net/6029854/uploads/defaultavatar/nZUSABQN8JEE0.jpg)
Hi,
SQL Source Control 4 identifies static data rows as different when they have a column of DATETIME2. For instance rows are stored in source control with the value '2014-01-10 11:35:10.2859999' but when viewed in the table they are reported as '2014-01-10 11:35:10.2859998'.
SQL Source Control 4 identifies static data rows as different when they have a column of DATETIME2. For instance rows are stored in source control with the value '2014-01-10 11:35:10.2859999' but when viewed in the table they are reported as '2014-01-10 11:35:10.2859998'.
Comments
Sorry about this. This is a bug with reference SDC-1744. Unfortunately I don't currently have a timeframe for when this will be fixed.
Redgate Software
Redgate Software
The latest version of SQL Source Control contains the fix for this issue. Could you try it and verify that it fixes the problem for you? Here's a download link if you need it - ftp://support.red-gate.com/patches/SQLS ... .3.575.exe
Thanks.
Redgate Software