sql server replication: Implicit conversion from data type text to nvarchar is not allowed -- sql server replication

Implicit conversion from data type text to nvarchar is not allowed

Jonas Larsen
5/31/2006 5:03:01 PM

sql server replication:

Hi guys

I currently trying to setup transactional updatable replication between a
server in Australia and one in France.
All goes according to plan until I begin pushing the subscription to the
France server. After awhile (Say 30 min or so) I get the following message:

Implicit conversion from data type text to nvarchar is not allowed. Use the
CONVERT function to run this query.

What I have done is change the data types to nvarchar. Deleted the old
subscription and created a new one. However this doesnt seem to help I still
end up with the same error message. The only tables in the database that
contains the text or ntext data types are 'sysarticles' and
'sysextendedarticlesview'. I still get the same error.

Any Ideas?

Thanks.

Regards
Jonas

RE: Implicit conversion from data type text to nvarchar is not allowed

Jonas Larsen
5/31/2006 5:33:01 PM

[quoted text, click to view]

Further: One server is Windows2000 Adv Srv SQL2000 SP4(Publisher) the
subscriber is Win2003 SQL2000 SP4

[quoted text, click to view]

RE: Implicit conversion from data type text to nvarchar is not allowed

Jonas Larsen
6/1/2006 2:19:02 AM

Hi Paul

Thanks for you response. However I finally realised that the problem table
had a character_maximum_length in excess of 20000 once thet was optimised to
below 8060 it worked fine so I asume that that was the problem.

Again thanks for your time much appreciated.

Regards
Jonas

[quoted text, click to view]

Re: Implicit conversion from data type text to nvarchar is not allowed

Paul Ibison
6/1/2006 9:43:11 AM

Jonas,
are you replicating the execution of stored procedures perhaps? Either way,
please can you enable logging of the distribution agent and we'll try to see
what's going on (http://support.microsoft.com/?id=312292).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Re: Implicit conversion from data type text to nvarchar is not allowed

Paul Ibison
6/1/2006 10:42:25 AM

OK - thanks for the update. Very strange error this one - I'll repro and add
to my site.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.