Replicating Text or Image data
I had a support request recently from one of our clients who wanted was trying to replicate our database to a reporting server. One of our legacy tables contains text data and transactional replication was failing with the error
SQL Server can be configured to allow a maximum size, in bytes, of text or image data which can be replicated. This applies to each insert, update, writetext or updatetext statement issued.
The default is 65536 bytes (64k). In our environment, 262144 bytes (256k) would be sufficient. Here is how to change this setting.
You do not need the advanced options enabled for this change.
sp_configure ‘max text repl size (B)’, 262144
go
reconfigure
go
To view the change, run
sp_configure ‘max text repl size (B)’
go
You should now see the config_value column now display 262144.