Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2000
Managing Servers
 max text repl size Option
Administering SQL Server (SQL Server 2000)
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

© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement | Site Feedback
Page view tracker