Today we talk about how to configure the max text repl size server configuration option in SQL Server by using SQL Server Management Studio or Transact-SQL.
The max text repl size option specifies the maximum size (in bytes) of text, ntext, varchar(max), nvarchar(max), varbinary(max), xml, and image data that can be added to a replicated column or captured column in a single INSERT, UPDATE, WRITETEXT, or UPDATETEXT statement.
The default value is 65536 bytes. A value of -1 indicates that there is no size limit, other than the limit imposed by the data type.
How to check present value on max text repl size using below queryThe max text repl size option specifies the maximum size (in bytes) of text, ntext, varchar(max), nvarchar(max), varbinary(max), xml, and image data that can be added to a replicated column or captured column in a single INSERT, UPDATE, WRITETEXT, or UPDATETEXT statement.
The default value is 65536 bytes. A value of -1 indicates that there is no size limit, other than the limit imposed by the data type.
EXEC sp_configure 'max text repl size (B)'
My customer requested to change Max Text Repl size value to 128 KB
max text repl size. i could changed the value using below query
EXEC sp_configure 'max text repl size (B)', 131072;
Using SQL Server Management Studio
To configure the max text repl size option
- In Object Explorer, right-click a server and select Properties.
- Click the Advanced node.
- Under Miscellaneous, change the Max Text Replication Size option to the desired value. 131072
