Insert a text file in a BLOB Field

• Samantha Neau

  Newbie

  Points: 1

  More actions

  December 7, 2004 at 2:29 am

  #108906

  I tried with an application to insert a text file around 70 Mo into a BLOB in SQLServer, the timming is awful more than 3 hours to load this file (with Oracle I need 15 min). I tried to use TEXTCOPY but there is an error Msg 7123 I think my file is too big.

  Someone has an idea ?

   

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  December 7, 2004 at 2:35 am

  #532787

  See, if this helps:

  http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]