Call: +46 (734) 084 500 | Email: mvp@sqltopia.com
The Filetime timestamp is nothing more than a serial counter of 100 nanoseconds since January 1st, 1601.To convert this timestamp to a DATETIME2-value in SQL Server (and avoid integer overflow), this is all you need to do.