Pieter, SWM, Martin,

Yes I was aware that it was used for default settings, was wondering if it had extra side effects.
Thanks for clearing up that it is only about mapping.

Especially as - unless I overlook something - the breaking change that Chuck linked only mentions a DATETIME to DATETIME2 conversion accuracy.
Is an SQL Server index doing an implicit conversion when it is created?
--
Wil