03/04/2006, 11:06
|
| | | Fecha de Ingreso: noviembre-2005
Mensajes: 658
Antigüedad: 18 años, 6 meses Puntos: 3 | |
| Collation Difference between SQL Server 7.0 and SQL Server 2000In SQL Server 7.0, there was a single collation setting for the server. Each database and column for each table used the same collation setting as the SQL Server 7.0 server setting. With SQL Server 2000, Microsoft has expanded the collation options available. In V2000, the server and each database can now have a different collation settings. Also, each column can have its own collation setting, which can be different from that of the server or database collation. Because SQL Server 2000 supports multiple collation settings, collation issues might arise when migrating databases from SQL Server 7.0 to SQL Server 2000 using the backup and restore method for copying databases. |