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

Comments

 

karin said:

By the way, Thank you for sharing with us, and we sincerely hope you will continue to update or post other articles.

http://www.realwoodhomes.us

http://www.ahousehome.us

http://www.ownlocalhomes.us

http://www.ibuyhomes4you.us

http://www.softhome100.us

http://www.ilovehomeroom.us

http://www.sprinterhomes.us

http://www.homelandstyle.us

http://www.homeadvisotr.us

http://www.purewater4home.us

http://www.flahomecare.us

http://www.mydailyhomedeco.us

http://www.homedesign88.us

http://www.homhomeaway.us

http://www.sweet-homes.us

http://www.dreamhome365.us

http://www.bonathome.us

http://www.nicehomedecore.us

http://www.hunthomeforsale.us

http://www.7dayhomesellers.us

http://healthreign.com

http://soulbusinessiq.com

http://ustravel-visa.com

http://technology-xchange.com

http://ahousehome.com

http://mhealthinsiders.com

http://businessacount.com

http://travelerstest.com

http://themissingtechnology.com

http://ibuyhomes4you.com

http://healthyfitlines.com

http://concisebusiness.com

http://safir-travel.com

http://deceptivetechnology.com

http://softhome100.com

http://healthmina.com

http://exporbusiness.com

http://travelwebportal.com

http://sweetechnology.com

http://ilovehomeroom.com

http://lifefithealthy.com

http://9thbusiness.com

http://travelasia123.com

http://technologynewsdesk.com

http://homelandstyle.com

http://bighealthtimes.com

http://facing-business.com

http://travelbaseltd.com

http://greatmindstechnology.com

http://homeadvisotr.com

http://wonhealthy.com

http://business24hours.com

http://travellovelive.com

http://newtechnologyline.com

http://homedesign88.com

http://healthypurebody.com

http://upstartbusiness.com

http://globaltravelbuy.com

http://theluxurytechnology.com

http://homhomeaway.com

http://healthnewsbot.com

http://mybusinessocial.com

http://travelsellerz.com

http://linksofttechnology.com

http://dreamhome365.com

http://healthnutbeauty.com

http://mybusinesscamp.com

http://jannattravels.com

http://logistic-technology.com

http://nicehomedecore.com

http://www.healthreign.com

http://www.soulbusinessiq.com

http://www.ustravel-visa.com

http://www.technology-xchange.com

http://www.ahousehome.com

http://www.mhealthinsiders.com

http://www.businessacount.com

http://www.travelerstest.com

http://www.themissingtechnology.com

http://www.ibuyhomes4you.com

http://www.healthyfitlines.com

http://www.concisebusiness.com

http://www.safir-travel.com

http://www.deceptivetechnology.com

http://www.softhome100.com

http://www.healthmina.com

http://www.exporbusiness.com

http://www.travelwebportal.com

http://www.sweetechnology.com

http://www.ilovehomeroom.com

http://www.lifefithealthy.com

http://www.9thbusiness.com

http://www.travelasia123.com

http://www.technologynewsdesk.com

http://www.homelandstyle.com

http://www.bighealthtimes.com

http://www.facing-business.com

http://www.travelbaseltd.com

http://www.greatmindstechnology.com

http://www.homeadvisotr.com

October 23, 2017 3:48 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Privacy Statement