INF: How to Install Localized SQL Server Error Messages (277535)

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

Back up the master database.
Extract the files from the s70xlang.exe self-expanding executable according to the directions provided by Microsoft Product Support Services.
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.
Back up the master database again.

SQL Server 2000 Installation Instructions

Back up the master database.
Extract the files from the s80xlang.exe self-expanding file according to the directions provided by Microsoft Product Support Services.
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.
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.
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.
Back up the master database again.