THE SQL Server Blog Spot on the Web

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

Aaron Bertrand

Aaron is a senior consultant for SQL Sentry, Inc., makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He has been blogging here at sqlblog.com since 2006, focusing on manageability, performance, and new features; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at user group meetings and SQL Saturday events.

How do the links in YOUR copy of SQL Server 2008 Books Online work?

I am just taking a quick show of hands; and maybe some information, if you are willing.  (And if this hasn't happened to you, I apologize for taking up your time.)

I have had various problems on multiple installations of Books Online throughout the entire Katmai / SQL Server 2008 cycle.  They have been on both 32 and 64-bit; with / without IE8 installed; and with / without Visual Studio installed.

Currently I have one instance where IE8 is not installed, BOL is alongside 2005 on Server 2003, and every single link is not clickable at all.  Just no response... I can only navigate to items through the index or search results.  On a similar machine the links work, but every single one leads to a page that says, "Sorry, no topics were found for the selected link."  Again I must navigate via index or search results.  Which is really too bad, because some of those links are much tougher to track down.  And now I came across a much more isolated case where on a Vista SP1 machine with IE8 installed, a certain link leads to this "sorry" page from one topic, but not from another topic (the difference is an xmlns attribute in the link, which I think may be the cause of the problem).

You can see what I am talking about in more detail in the following Connect items:

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=290461

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=357008

(I have some other items about messed-up formatting in IE8, and a lot of others have submitted the same.  But I am more curious here about the links, as the formatting issue is being addressed.)

I can't imagine that this kind of thing happens differently across every single machine / VM I use, but it doesn't happen to anyone else?  If you have had any issues clicking links in Books Online, please drop a note here providing any specific information we can relay back to Microsoft so they can try harder to reproduce these issues.  I mean really, I am not making this stuff up... please help me escape from this madness!

Thanks!

Published Saturday, July 19, 2008 8:55 PM by AaronBertrand

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

 

AaronBertrand said:

Wow, I guess I am the only one with these problems.  <shrug>  How did I screw up all of my machines this badly, and in slightly different ways, leaving me with not a single functional copy of SQL Server 2008 BOL?

July 23, 2008 9:11 AM
 

David said:

Sorry for the late response, just subscribed to your blog feed.

Can't say that I have had more than a couple of link problems just more on the missing content side. Stuff that should be clear in the index list is not there and when reverting back to 2005 BOL (mainly to check my sanity) I find it immediately. So, there is certainly some work that needed to be done prior to the final release.

July 29, 2008 11:05 AM
 

Hugo said:

I've also had the problem where clicking on a MSHelp-link would almost always result in a  "Sorry, no topics were found for the selected link"  message, for all local SQL Server 2008 and Visual Studio 2008 documentation. Reinstalled Document Explorer (2005 and 2008) and the documentation, but to no avail. Happened with IE7 and IE8, regardless of the security settings.

Just found out that this problem was caused by an ActiveX killbit being set, somehow, for hxds.dll, the Microsoft Help Data Service Module v2.5, class HxSession. Removed the killbit and now the MSHelp-links work fine.

You can find the killbit setting here: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\{31411198-A502-11D2-BBCA-00C04F8EC294}

If DWORD value "Compatibility Flags" is set to 0x00000400 (1024), the killbit is set and the hyperlinks won't work. Set it to 0 and the hyperlinks should work again after restarting Document Explorer. This might increase the IE attack surface though.

March 24, 2009 4:37 PM
 

M.Afifi said:

Hi Aaron,

I have exactly the same problem. I am googling sometime ago but could not find a solution. The killbit Hugo talked about is not found in my registry.

Could you solve this problem? I would appreciate if you tell us how.

Thanks in advance

May 26, 2011 2:07 PM

Leave a Comment

(required) 
(optional)
(required) 
Submit

About AaronBertrand

...about me...

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement