Sql Server 2005 crashes on SqlBulkCopy RRS feed

  • Question

  • Hi,


      I used SqlBulkCopy of ASP.net 2.0 to load a datatable to sql server 2005 database. One of the columns is middle intial whose datatype is varchar(1) in the database. When trying to load a datatable that has middle initial value of size > 1 the Sql Server 2005 crashes with transport level error/exception (On our production server we noticed it did however restart automatically).


    Isn't Sql Server supposed to throw up an exception without crashing or better yet just truncate the data while loading into datatable.



    Wednesday, August 29, 2007 6:24 PM

All replies

  • hii

    The sql serever not throw exception in this case u ahve to send data to database as per the datafield defined in there no truncation will be done at there....!



    Thursday, August 30, 2007 5:58 AM
  • But why does the Sql Server 2005 crash ? Is it some kind of bug ?


    Tuesday, September 4, 2007 1:47 AM