• So, if the SQL Server 2000 server was upgraded to SQL Server 2005 or 2008 R2, the transactional replication could work for the disparate collations?

    Also, to confirm, it is the fact that the 2008 SQL Server is version R2 that makes it one too many versions different from SQL Server 2000 for the replication to work?

    Thank you for the reply.