replication and blobs (text, ntext, image)

On my team, like most teams, we have a development, test and production database. We move data from test (sometimes called build) every evening to production. In the past, and we still do some today, we have ColdFusion scheduled tasks that run every evening to move the data.

In the past few months, after hiring a full-time SQL Server DBA, we have been moving to Replication and removing the ColdFusion scheduled tasks to move data. Today, we ran into a snag. We had changed a table over to Replication that contained a Blob (image) column. When trying to insert into that table, we received this error from SQL Server:

It seems that when Replication was set up, there was a max length put on that field when data is moved over. To fix it, we needed to up the "limit". We ran this script:

Basically, we upped the limit to 10MB. Now, this takes care of all text, ntext and image columns in tables that are replicated, but it makes Replication slower. With the amount of data in our tables, we probably won't see much of a change if any in speed of the Replication job.