Ntext replication - Max size exceeded

Hi,
I am facing one wierd problem.

I have one table having column as Ntext, from front end we are inserting
50000 characters.Replication is enabled , when we are inserting 50K
characters we are getting error

"Length of text, ntext, or image data (100000) to be replicated exceeds
configured maximum 65536.The statement has been terminated"

Is it because column is ntext and internally sql server treat this as double
byte character and try to insert 100000 characters. replication by default
supports 65536 characters...
i am bit confused on this sql behavior/


--
Sanjay

The 'max text repl size' specifies the max size *in bytes* so you need to
double the number of characters for ntext to calculate the number of bytes.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Sanjay" <Sanjay@discussions.microsoft.com> wrote in message
news:BC35046F-BC44-4C02-8BBF- 6533BF5897AA@microso
ft.com...
> Hi,
> I am facing one wierd problem.
>
> I have one table having column as Ntext, from front end we are inserting
> 50000 characters.Replication is enabled , when we are inserting 50K
> characters we are getting error
>
> "Length of text, ntext, or image data (100000) to be replicated exceeds
> configured maximum 65536.The statement has been terminated"
>
> Is it because column is ntext and internally sql server treat this as
> double
> byte character and try to insert 100000 characters. replication by default
> supports 65536 characters...
> i am bit confused on this sql behavior/
>
>
> --
> Sanjay