sp_oamethod issue? writeline truncates the line...

• oldgoat

  SSCrazy

  Points: 2344

  More actions

  October 20, 2004 at 5:02 am

  #86698

  using

  exec @fsoe = sp_oamethod @fm, 'writeline' , NULL, @instring

  I've noticed that no matter how large @instring is - its a varchar(5000) - the resulting line in the file is truncated at 256 characters.

  is this an SQL thing or a filesystemobject thing?

  More important, how do I get around it?

• oldgoat

  SSCrazy

  Points: 2344

  More actions

  October 20, 2004 at 6:10 am

  #527304

  IGNORE!

  found the answer, though the MS reasoning isn't too good.

  6.5 and 7 (had) bug that chopped the string into 256 char chunks, but then had a problem with it.

  with 2k it at least uses the first chunk...

  anyway, using write method instead works fine!