Menu
Here is a related question.
Why do I get this error even when I have not installed SQL Server replication ? The strangest thing is, when I run the fix
sp_configure 'max text repl size', 2147483647 Go RECONFIGURE GO it works and I no longer get this error
735
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.
Large Objects (LOBs) are a set of datatypes that are designed to hold large amounts of data. A LOB can hold up to a maximum size ranging from 8 terabytes to 128 terabytes depending on how your database is configured. Storing data in LOBs enables you to access and manipulate the data efficiently in your application.
The following steps should be performed:
44
Are you using Change Data Capture?
From How to: Configure the max text repl size Option (SQL Server Management Studio)
This option applies to transactional replication and Change Data Capture
120
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
