Article ID : 923563
Last Review : June 19, 2007
Revision : 1.1

FIX: Error message when you configure an immediate updating transactional replication in SQL Server 2000: "Implicit conversion from datatype 'text' to 'nvarchar' is not allowed"

CAUSE
This problem occurs when the synchronization trigger definition for an updatable subscription is longer than 4,000 characters. The internal buffer for the trigger definition is limited to 4,000 characters.
----------------------

if anyone has one please send to
sm.ch@163.com
thank you very much.