translations.php is not converting 0000-00-00 00:00:00 to the current date. Instead, queries are attempting to do inserts into SQL Server datetime fields with 0000-00-00 00:00:00, which is an invalid date in SQL Server, although it might be OK in MySQL. Please check the logic in translations.php to make sure that the conversion to a current date value is happening correctly.
http://wordpress.org/extend/plugins/wordpress-database-abstraction/