SQL Server Issues
The primary site server and the SMS site database can reside on different language and code page computers on your network. Also, if your primary site server will have DBCS child sites or clients, Microsoft SQL Server versions 6.5 and 7.0 support both single-byte and double-byte character sets. Therefore, all characters from the 24 potential client languages can be stored in the SMS site (SQL Server) database. However, consider the following points:
- You can use the English-language version of SQL Server 6.5 or 7.0 with any of the SMS 2.0 site server language versions, or you can pair local-language versions of SQL Server 6.5 or 7.0 with a matching localized version of SMS 2.0. For example, an SMS administrator in Bonn can use a German-language SMS site server with either a German-language or English-language version of SQL Server.
- SQL Server 6.5 and 7.0 are only available in English and Japanese for the Alpha platform. This is not a significant limitation, however, because the English versions of SQL Server support both single-byte and double-byte character sets.
- If your database contains mixed-language data, you are limited to a single sort order. You select the sort order during SQL Server setup. For more information, see your SQL Server product documentation.