• I had a feeling that would be the case. We're currently migrating an old Datawarehouse from SQL 2000 to SQL 2008 R2 and obviously we want the data to match across the systems.

    Fixing the problem is easy enough but this means we are left with inconsistencies between the two systems which isn't ideal.