Verifying code page settings for SQL Server

The procedure in this section outlines the minimum requirements of a SQL Server environment to run Release 9.2. After completing this procedure, the database might still require significant modifications, such as tuning the system, creating backup or recovery procedures and jobs, and maintaining or expanding the database system.

Note: When installing or upgrading an alternate language, the correct code page settings must be in your database. When installing or upgrading the database, set up the code page for the language before loading your language specification objects for Release 9.2. Review the LocalCodeSet and code page settings for your database machine environment.

From an ISQL window, enter this command:

sp_helpsort

Caution: If the character set is incorrect, recreate the database with the correct character set.

See Also

Refer to the Language Process Overview for the National Language Support tables and other information related to multilingual installations.