You are installing a new server with SQL Server 2008. Your sister company runs SQL Server 7.0 SP4. You need to replicate data between the two servers regularly. What collation setting should you use?

You are installing a new server with SQL Server 2008. Your sister company runs SQL Server 7.0 SP4. You need to replicate data between the two servers regularly. What collation setting should you use?

You are installing a new server with SQL Server 2008. Your sister company runs SQL Server 7.0 SP4. You need to replicate data between the two servers regularly. What collation setting should you use?


Answer – SQL Collation

(To replicate with versions of SQL Server older than 2000, you need to select the SQL Collation setting.)