Post reply

Replicating more then 65 KB of Image (Blob) Field

  • February 20, 2009 at 3:49 pm

    #200506

    I am looking for the solution to replicate the image field more the 65 KB using Transactional Replication.

    As it does for the small images, do we have parameter or technique to remove the blob size limitation from the SQL Server 2005?

    Please provide your inputs.

    Thapa

  • February 20, 2009 at 4:52 pm

    #948044

    It's a configuration setting, which can viewed and changed using sp_configure.

    See "max text repl size option" in BOL.

    -- View your current settings

    exec sp_configure

    -- Change the max text/image size for replication

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

    -Eddie

    Eddie Wuerch
    MCM: SQL

  • February 21, 2009 at 11:20 am

    #948188

    Hi Eddie

    I will try this. Hope this should work.

    Thanks

    Thapa

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

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