max text repl size Option

Administering SQL Server

Administering SQL Server

max text repl size Option

Use the max text repl size option to specify the maximum size (in bytes) of text and image data that can be added to a replicated column in a single INSERT, UPDATE, WRITETEXT, or UPDATETEXT statement.

The setting takes effect immediately (without a server stop and restart).

To set the max text repl size option

Transact-SQL

SQL-DMO

See Also

INSERT

RECONFIGURE

Replication Overview

Setting Configuration Options

sp_configure

UPDATE

UPDATETEXT

WRITETEXT