Books Online Help..

I have installed SQL Server 2000 Personal edition on my desktop, which has a C: and a D: drive. All the program files, WINNT folder are on D: drive and the SQL Server has also been installed on the D: Drive.
Now when I try to open the Books online then I get the error " unable to open D:\Program files\Microsoft SQL Server\~sql80.col.
Any help??Have you tried reinstalling?

Did you check to see whether sql80.col exists on your D drive?

Do you get this error when you invoke the help system through both the Windows Menu bar and Query Analyzer's help menu?

Can you run the following command:
C:\WINNT\hh.exe "D:\Program Files\Microsoft SQL Server\80\Tools\Books\SQL80.col"?

blindman|||The location should be "D:\Program Files\Microsoft SQL Server\80\Tools\Books\SQL80.col"

Bold in a textbox ms-access

In my reports of MS-ACCESS I need to combine Bold in a textbox. I do not program in VB

so I would like something like this:

=Format([name],"bold" & " " & [lastname])

and the output shoul be

Mike Andersen

Is it posible to do?

no it isnt, ms-access doesnt support different styles in on textbox (as far as i know)

a little workaround would be to create 2 textboxes next to each other

the first bold, the second normal

sql

Bold in a textbox ms-access

In my reports of MS-ACCESS I need to combine Bold in a textbox. I do not program in VB

so I would like something like this:

=Format([name],"bold" & " " & [lastname])

and the output shoul be

Mike Andersen

Is it posible to do?

no it isnt, ms-access doesnt support different styles in on textbox (as far as i know)

a little workaround would be to create 2 textboxes next to each other

the first bold, the second normal

BOL May 2007 shows no index and no table of contents

I downloaded and installed SqlServer2K5_BOL_May2007.msi, and it had no index and no table of contents. The shortcut is
"C:\Program Files\Common Files\Microsoft Shared\Help 8\dexplore.exe" /helpcol ms-help://MS.SQLCC.v9 /usehelpsettings SQLServerBooksOnline.9.0 /LaunchFKeywordTopic sql9.portal.f1

there are table of contents files:

Directory of C:\Program Files\Microsoft SQL Server\90\Tools\Books\1033

01/26/2007 11:59 AM 12,949 sql90.hxt
07/27/2006 07:53 AM 271 SQLCC.hxt
11/07/2006 02:16 PM 687 ssm3.hxt

and there are index files too -- the most important one seeming to be :

05/23/2007 12:44 PM 13,630,606 sql90.hxq

I re-executed the .msi and chose repair.
That didn't work to show the index or TC either.

I will try a reboot -- but then I'll have to resintall the previous BOL.

I downloaded and installed it, I was asked about a previous version and choose yes to override it. I am also running Katamai BOL both runs fine. I have no problems, so I think you should delete the download and get a new file for the next install. Hope this helps.|||TOC and index have showed up after a reboot. (Windows XP SP2)