Microsoft SQL Server 2000 extends the performance, reliability, quality and ease of use of Microsoft SQL Server 7.0, and is welcomed by users. For Chinese users, this is the first all-in-Chinese product of Microsoft SQL Server, especially its powerful online help, which makes us a lot of convenience. But in practice, we sometimes need the English interface, and in the case of training, we hope to help you with the knowledge of professional vocabulary through the Chinese interface and English interface. So, how can I achieve interface interchange in Chinese and English?
First, let's take a look at the installation path of the tool.
If the Microsoft SQL Server 2000 Chinese version is installed, all tools are installed in the C: / Program Files / Microsoft SQL Server / Program Files / Binn directory, and our most commonly used Query Analyzer corresponds to the isqlw.exe file , The event search device corresponds to Profiler.exe, etc.
Second, let us understand the role of resource documents
In order to realize the multi-language support of the product, Microsoft has passed the resource file implementation, the same product, because the resource file changes to different languages, the corresponding interface is automatically modified to the language interface, and the resources subdirectory under the binn directory is to complete the above tasks. . When we have installed the Chinese version of Microsoft SQL Server 2000, there are two subdirectories 1033 and 2052, 1033 in the Resources subdirectory, 2052 is a Chinese resource file. If you install an English version, there is only 1033 directories.
Here, let us implement interchange of Chinese and English interface. You only need to modify 2052 to another name, then the interface has all become English when you open the corresponding tools of SQL2000 next time. Naturally, if you want to return to the English interface, you only need to modify 2052.
What I mentioned is that the Chinese version of Microsoft SQL Server 2000 changes to English, then if my machine uses Win2000 in English, install SQL2000 in English, how to implement the interface. Based on the above principle, first, the English operating system will use the above 1033 directory instead of 2052 directories. Secondly, we need Chinese resource files, of course, Chinese resource files are not in English version SQL2000, you need to copy 2052 directory in the 2.552 directory, or copy SQL2000 Chinese installation disc, or copy SQL2000 Chinese installation disk X86 / binn / Res / other directory. Then, we modify the 1033 directory of the original English resource file to another directory, modify 2052 or other to 1033 directories, you can implement SQL2000 tools. Of course, the English operating system also needs to modify the zone settings into Chinese in the area option.