Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
SQL Server 2008 R2 Migration - sp_xml_preparedocument

Unanswered SQL Server 2008 R2 Migration - sp_xml_preparedocument

  • Friday, October 21, 2011 1:32 AM
     
     
    Sign In to Vote
    0

    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.

    Pls recommend

    Sudhakar g

    sudhakar.g@gradatim.co.in

    919886242340

     

     

All Replies

  • Friday, October 21, 2011 10:35 AM
    Answerer
     
     
    Sign In to Vote
    0

    Could this be due to a server locale or date setting?  Thoroughly inspect your server date settings, and SQL Server language / collations etc for discrepancies.

    Otherwise are you able to post a simple reproducible ("repro") which shows this problem?