I have a C#.NET application (although I'm not sure that the language
matters) that inserts files into an SQL server database. The files
have started to get large, so we get the error message:

Length of text, ntext, or image data (292800) to be replicated exceeds
configured maximum 65536.

for large files. After some research, the configuration setting that
needed to be changed was 'max_text_repl_size'. There are two
databases. One is being replicated from the other, so we reconfigured
both with the statement:

sp_configure 'max_text_repl_size' , 2097152

But we still get the exact same error message. If anyone can help, it
would be much appreciated.

Did you restart your sql servers after execute sp_configure? If not,
did you use the RECONFIGURE WITH OVERRIDE to enable the changes
immediately?

No. I didn't realize it was necessary (I'm a programmer not a db
admin).

I talked to our admin and he says that there's no way the db can be
restarted. How do I use the RECONFIGURE WITH OVERRIDE?

I imagine it's smt like

EXEC sp_configure 'max_text_repl_size', 2097152
RECONFIGURE WITH OVERRIDE

or

EXEC sp_configure 'max_text_repl_size', '2097152'
RECONFIGURE WITH OVERRIDE

Confusing, tsql ref shows configvalue Syntax with 2nd arg as a string
yet Arguments section states its an int. The examples show it as a
string yet you've apparently successfully used an int. Whatever,
hopefully this works for you

Got it working. The funny thing is that originally when I used
sp_configure (and I used the first syntax), the change worked fine
even without RECONFIGURE WITH OVERRIDE, (i.e. the run_value was also
changed), but later it quit working for some reason and the change did
not work until I used RECONFIGURE WITH OVERRIDE.

Thanks again.

Good for you!