Hi: Thanks for the valuable information. We have encountered another problem with transactional replication I wonder if you can help us.

Our user got an error: "Length of text, ntext, or image data (75916) to be replicated exceeds configured maximum 65536."

My question:

1. How big should we set sp_configure 'max text repl size'? Do we have to worry about memory when we set it too high?

2. How do we calculate the max text repl size from the tables we have? Some ot our tables have several image and ntext columns. Is there a formula to calculate this?

Thanks in advance for your help.

Cynthia