Post reply

replicating image/text, max size

  • July 9, 2004 at 8:09 am

    #86150

    I have a strange ODBC error message telling me that the maximum size has been exceeded for replicating ntext/image objects.  That maximum size is 10Mb.

    Does anyone know where the setting is for overriding this?

    LinkedIn Profile

  • July 11, 2004 at 5:51 pm

    #514219

    I believe that is a SQL Server Configuration Option.

    You have to use sp_configure. Not sure which setting though. Have a look in BOL or do a sp_configure on the SQL Server to see what the setting is called.

    You may have to show Advanced Options first with sp_configure.

    Kindest Regards,

  • July 12, 2004 at 1:45 am

    #514237

    Found it!

    USE master

    EXEC sp_configure 'max text repl size','<<size up to Gb expressed in byte>>'

    RECONFIGURE WITH OVERRIDE

    The default value is 65K

     

    LinkedIn Profile

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply