THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Tibor Karaszi

Local Books Online, as of 2017 August

This seems to be a never ending story, having a locally installed Books Online for SQL Server, that is. Some of you recall that I have posted about this before. This post is about my experiences for the current state of Books Online. Things has changed since I last blogged this. Among other things, MS has re-worked the documentation, including moving the online bit from MSDN to docs.

Background: I have a new machine, and with that I of course want to have a local Books Online for SQL Server. Following any of my previous post didn't quite work. Here is what I installed:

  • Windows 10, fresh installation
  • SQL Server 2016 (Db engine, SSIS, SSRS)
  • Patch above to current service pack and CU.
  • SQL Server Data Tools - BI
  • SSMS 17.2
  • Visual Studio 2017

There are of course other stuff on the machine as well, but I doubt that affect the SQL Server BOL experience. Here's what I did to get local BOL inside SSMS:

  1. Help
  2. Add and Remove Help Content
  3. Under "SQL Server" header, I just added the bits that I found interesting. In my case everything.
  4. Update
  5. Now it took a long while, since I missed the VS installation a monster-sized doc for Framework. I later removed the VS bits.
  6. I was also afraid that I experienced a bug in Help Viewer, where it would hang. It took a long while with status something like removing temp files. But it ended just fine, I didn't have to do the "kill, update help config file, and stuff", like I did before.

Bottom line is that it worked just as I expected, or perhaps I should say "hoped for". :-)
(Well, almost. Some entries are doubled. I don't actually bothered (much) about that so I just ignore that. For instance under "SQL Server Technical Documentation" I have two of both "Overview" and "Release Notes".)

What more? Well, we probably want local BOL to be the "F1"-help:

  1. Help
  2. Set Help Preference
  3. Launch in Help Viewer 

Also, your might want to create a shortcut (on desktop, start menu, or wherever), which points to:
C:\Program Files (x86)\Microsoft Help Viewer\v2.2\HlpViewer.exe" /catalogName SSMS17 /locale en-US

 

For reference, here are two prior posts on the subject. But don't go there, they will confuse you. I only list them here as a reference, and *in case* you might end up with a hung help viewer etc... 
Bol 2016 blog 1 
Bol 2016 blog 2 

Published Tuesday, August 15, 2017 9:04 AM by TiborKaraszi
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Privacy Statement