Microsoft KB Archive/277535

= INF: How to Install Localized SQL Server Error Messages =

Article ID: 277535

Article Last Modified on 10/31/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q277535



SUMMARY
This article describes how to install localized error messages into SQL Server so that the client application receives error messages in their default language instead of the language that SQL Server was installed with.

For SQL Server 7.0 you can add the following localized error messages to a server:


 * French
 * German
 * Japanese
 * Spanish

For SQL Server 2000 you can add the following localized error messages to a server:
 * Brazilian
 * Chinese, Simplified
 * Chinese, Traditional
 * Dutch
 * French
 * German
 * Italian
 * Japanese
 * Korean
 * Spanish
 * Swedish



MORE INFORMATION
You can set the default language for a connection by using one of the following options:


 * Add a login with the sp_addlogin stored procedure and pass the @language parameter.
 * Use the sp_defaultlanguage stored procedure on an existing login.
 * Use the SET LANGUAGE Transact-SQL command.

To add localized error messages to SQL Server in languages other than English and the version language of SQL Server, contact Microsoft Product Support Services to obtain the appropriate file for your version of SQL Server.

  File name        Version

s70xlang.exe    7.0 s80xlang.exe    2000 (8.0) SQL Server 7.0 Installation Instructions


 * 1) Back up the master database.
 * 2) Extract the files from the s70xlang.exe self-expanding executable according to the directions provided by Microsoft Product Support Services.
 * 3) Connect to SQL Server with a query tool (such as ISQL or Query Analyzer) with a login that has sysadmin rights on the server, and then run the 7xsysmsgs.sql script that is contained in s70xlang.exe.
 * 4) Back up the master database again.

SQL Server 2000 Installation Instructions


 * 1) Back up the master database.
 * 2) Extract the files from the s80xlang.exe self-expanding file according to the directions provided by Microsoft Product Support Services.
 * 3) Run the application 8xMultiLangSysmessages.exe that is contained in s80xlang.exe, and then choose a temporary location for the files.

NOTE: This step requires approximately 20 MB of available disk space.
 * 1) Connect to SQL Server with a query tool (such as ISQL or Query Analyzer) with a login that has sysadmin rights on the server, and then run the 8sysmsg.sql script located in the temporary directory chosen previously.
 * 2) Copy the directories that were created under the temporary directory that are named with numbers, to the Binn\Resources directory in which SQL Server was installed. If a directory with that name exists under the Binn\Resources directory then you do not need to copy that directory.
 * 3) Back up the master database again.

Additional query words: language

Keywords: kbinfo KB277535

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.