We have recently migrated from SQL Server 2005 to SQL Server 2008 R2. While testing we have used Windows Server 2003 as web application and WIndows Server 2008 with SQL Server 2008 R2 as database server. This was working fine without any issues.
But when we used Windows Server 2008/IIS 7.0 as web application and Windows Server 2008/SQL Server 2008 R2 as a database server. sp_xml_preparedocument throws an exception of conversion of datetime. "Cannot convert DateTime".
Is there any limitation with sp_xml_preparedocument. As most of our application uses this to do a bulk insertion.