Well... as least we're finally at a Resolved status. Thanks for your perseverance, hopefully anyone stumbling across this same issue in SQL Server will make it all the way to the end and save themselves a lot of time.
I've stashed this away in my Favorites on the off-chance I have the... pleasure... of working with that particular database.
Insert date value into SQL Server datetime columm
Moderators: chulett, rschirm, roy