useoledbstreaming - Problem with replicate a Blob Field

• AndreT78

  Mr or Mrs. 500

  Points: 574

  More actions

  November 26, 2009 at 1:45 am

  #228179

  Hi,

  I have a Problem to replicate a ntext Field with huge Blob-Data.

  The Error Message is :

  (Die Anweisung wurde beendet. Die Länger der zu replizierenden LOB-Daten (82284) überschreitet den konfigurierten maximalen Wert 65536.)

  The statement has been terminated. The length of the LOB data to be replicated (82284) exceeds the configured maximum value 65536.

  i found in the MS-Help this

  http://msdn.microsoft.com/en-us/library/ms147328.aspx

  I have to configure the values for

  -UseOledbStreaming

  and

  -OledbStreamThreshold

  The Last one ist not the Problem, but the "-UseOledbStreaming" - Value get an Error.

  "The value must be an integer", but i set only Integer-Values in this Field.

  Can someone help me, to resolve my Problem to replicate the Blob-Data or to set the value vor this Parameter (script?) ?

  Many Thanks

  Andre

  PS: Sorry vor my bad English :crying:

• AndreT78

  Mr or Mrs. 500

  Points: 574

  More actions

  November 26, 2009 at 2:09 am

  #1084481

  it is so easy :w00t:

  i have found the answer a few minutes after i posted this her.

  exec sp_configure

  exec sp_configure 'max text repl size (B)', 131072

  reconfigure