"SQL" SQL2012 offline Help document installation not on the processing notes

Note: Workaround at the end, impatient children's shoes can be scrolled straight down.

My SQL instance is version R2, because there are some fucking problems with the version of SSMs (Microsoft SQL Server Management Studio management tool), for example:

-The operation of a rectangular text block (Alt + left mouse button selection) is not supported in the text editor, such as multiple lines of bulk typing, block pasting, etc.

-When you copy a result set, the carriage return in the cell changes to two spaces, not exactly the cell value, which is particularly fucked

So I installed the standalone version of SSMs (https://www.microsoft.com/zh-CN/download/details.aspx?id=42299, click "Download" After choosing Sqlmanagementstudio_x64_chs.exe), yes, with the 2014 version of the management tool to manage the 08R2 version of the instance, but the standalone version of SSMs does not have a help document, so after the installation is complete, in the Help viewer does not find anything, very inconvenient, So I thought about loading the help document. Originally wanted to install 08R2 version of the help, after all, the example is 08R2, all development should be around this version, and the new version of the help will inevitably be more than some new features of the document, will cause interference or even misleading, but find to find to always find 08r2 offline help, had to retreat and second, installed 2012 version of the Help. It could have been installed directly using the "online install content" from the Help Viewer, but the download speed was unbearable and who knew who it was, so take the offline help and install it "from disk," 2012 offline Help:/http www.microsoft.com/zh-cn/download/details.aspx?id=347.

Download Down is a self-extracting file called "Sqlserver2012documentation_june_chs.exe", double-click → Select the location to extract, get the Directory "Sqlserver2012documentation_june_chs",

where "Helpcontentsetup.msha" is available to "Install content from disk" Selection of the Msha file, all the way, to the actual installation will inevitably pop up the following error:

Well, look at the log (running Eventvwr.msc), and sure enough, there's this one:

But there is a cock with, then find degrees Niang, there are so few to say this problem, but did not say what the why. But well, at least to show that this problem is not a person I met, it should be a common problem, the basic can be ruled out the cause of the environment. Continue to toss.

In the churn Help manager, it was found that one of the interfaces mentioned a path,

As I understand it, this is where the offline Help is stored (after study, OK, this should be just the offline help for MS to install the package storage directory, help after installation, content will be released to C:\ProgramData\Microsoft\HelpLibrary\ Content\microsoft\store, which is the difference between the directory where the software installation package is located and the Software installation directory, is found to have some helpcontentsetup.msha, holding a try attitude, "Install content from disk" When the choice of these msha tried, no error, a chance, put Msha file into Notepad, very good, can normal display, is an HTML description of the file, then compare the download of the Helpcontentsetup.msha and helplibrary in the difference between:

This process is painful, because the msha inside refers to other html/xml files, which refer to other Html/xml files, the final reference to the actual Help content file (Cab package), the whole is a file reference chain, each link may be the reason, I am the chain on the related files to only reference a CAB case, still error, considering whether it is the version of the CAB package, damage and other problems, and the normal cab exchange, the relevant href changed to try again, the problem is still ~nnd, I do not superstitious, decided to start from the end of the chain, Gradually replaced by the normal installation of the content, replace a ring to try once, until the Helpcontentsetup.msha replaced, finally normal, that the TMD problem is out on the MSHA, since the lock is this goods, open big eyes also want to pull out the problem. Fortunately MSHA content is not many, just a few lines, the problem of msha and normal msha have some differences, including innertext on the order of the label, I will control the normal MSHA progressive modification, try again, until you see <span class= "locale" >zh-zn</span>:

Your sister Ah, ZH-ZN is a god horse thing, instantly feel the problem caught. On a lesson, and later to find the MS problem, must not ignore the spelling error of this mentally retarded reason, the writer of this document should be dragged out to cut JJ, damn! Mistakes are not uncommon, but you do not have the TM test, you TM so long time have not found this problem, Ms TM raised some people.

For more information about language/region codes, see:

Http://zh.wikipedia.org/wiki/ISO_639-1

Http://zh.wikipedia.org/wiki/ISO_3166-1

BTW, after knowing the reason, then use Helpcontentsetup.msha zh-zn for the keyword to search Baidu, Tnnd can search, in fact, early found this problem, http://www.cnblogs.com/lipengzhou/p/ 3750815.html, Baidu You can rely on the dot spectrum.

Solution: Use Notepad to open the Helpcontentsetup.msha, the ZH-ZN changed to ZH-CN, save can.

-Wenbi-

"SQL" SQL2012 offline Help document installation not on the processing notes