I have two servers with different collations. I perfer having all databases on the server to have the same collation. I am using transactional replication to replicate a database from server A(collation1) to server B (collation 2) . How can
i overcome the difference in collation?
When replicating articles there is an option, copy collation (true/false). Can this feature help ?
View Complete Post