Results 1 to 3 of 3

Thread: REplication of image data (urgent)

  1. #1
    Mike Guest

    REplication of image data (urgent)


    Hello everyone,

    I'm running merge replication with several databases. So far everything worked fine, but now I tried to insert some new records and I get the message:

    Server: Msg 7139, Level 16, State 1, Line 1
    Length of text, ntext, or image data (73728) to be replicated exceeds configured maximum 65536.
    The statement has been terminated.

    Can anybody tell me how if I can change this max. value and how ?
    Thanks a lot
    Mike B.

  2. #2
    Markus Guest

    REplication of image data (urgent) (reply)

    Hi Mike,

    you'll hve to change the server configuration option max text repl size using sp_configure.

    Markus


    ------------
    Mike at 5/3/2002 10:22:13 AM


    Hello everyone,

    I'm running merge replication with several databases. So far everything worked fine, but now I tried to insert some new records and I get the message:

    Server: Msg 7139, Level 16, State 1, Line 1
    Length of text, ntext, or image data (73728) to be replicated exceeds configured maximum 65536.
    The statement has been terminated.

    Can anybody tell me how if I can change this max. value and how ?
    Thanks a lot
    Mike B.

  3. #3
    Join Date
    Dec 2008
    Posts
    1

    Thumbs up Max Size Increased Like this

    Declare @NewSize bigint
    Set @NewSize = 100000000
    print 'Old size'
    exec sp_configure 'max text repl size'

    print ' Setting new size'
    exec sp_configure 'max text repl size', @NewSize

    print 'Reconfiguring'
    RECONFIGURE WITH OVERRIDE

    print 'New size'
    exec sp_configure 'max text repl size'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •