Can some please tell me how to increase LOB size?

• Mr J

  Hall of Fame

  Points: 3594

  More actions

  February 24, 2009 at 4:33 pm

  #134939

  Hello,

  I've just setup a new server to replace an existing one that kicked the bucket and i have a slight issue with the following error

  Length of LOB data (65772) to be replicated exceeds configured maximum 65536. The statement has been terminated.

  Is anyone about to tell me how to increase the configured maximum size ???

  Cheers 🙂

  Remember
  Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!

• Mr J

  Hall of Fame

  Points: 3594

  More actions

  February 24, 2009 at 4:43 pm

  #949710

  hehe found the answer with a bit of digging, but for those who want to know

  sp_configure 'max text repl size',

  Cheers

  Remember
  Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!