max text repl size
Type: Basic
Default value: 65536
The max text repl size
parameter specifies the maximum size of the text
, ntext
, varchar(max)
, nvarchar(max)
, and image
data types for columns participating in replication during single insert
, update
, writetext
, and updatetext
statements. You might need to raise this value if the image sizes your application deals with are consistently large and the data is part of a replication configuration.
The following is an example of this option:
exec sp_configure 'max text repl size', 131072goRECONFIGUREgo
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.