• Different collations shouldn't be an issue.

    What could be an issue is newer datatypes in use in the tables being replication. These cannot be replicated. Otherwise, I don't see a problem but I wouldn't necessarily recommend it since SQL 2000 is no longer supported.

    Is there anything preventing you from taking the opportunity to upgrade to a supported version of SQL?