adding Replication caused Length of LOB data error

[Ted]

we are getting an error when we are trying to copy an entire tree structure in our database after adding replication.  Anyone have any thoughts on how to fix this.  worked fine until replication was added to the tables.

Insert of '437937710-' failed: Telerik.OpenAccess.RT.sql.SQLException: Length of LOB data (197434) to be replicated exceeds configured maximum 65536.\r\nThe statement has been terminated.\r\n   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.execute()\r\n   at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.execute()\r\n   at OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes)\n

[Ady]

Hi Ted,

This error occurs when the default maximum text replication size (65536) for a column is exceeded. You can modify this value using the following procedure -
EXEC sp_configure ‘max text repl size’, -1

You can also modify this setting via 'Sql Server Management Studio' by selecting the server in the 'Object Explorer', right click and select 'Properties' ,'Advanced' node and modify the property in the 'Miscellaneous' section.

Do get back in case you need further assistance.

Best wishes,
Ady
the Telerik team

[Ted]

That worked.  Thank you.