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"

Bizarre login behavior.

sql2k
sp3
I have two db's, each with a WINNT login named DBATest. DBATest is a member
of Security Admins as well as db_accessadmin and db_securityadmin in both
DB's. However, in one DB he can see the Users and Roles, and in the other he
cant. How can it be?
TIA, ChrisRIt turned out to be that Public was granted Select on all the System tables
in one DB but not the other. It would seem that if a user was added to
db_accessadmin and db_securityadmin, something like a trigger would make sure
the correct systems tables had Select, but oh well.
"ChrisR" wrote:
> sql2k
> sp3
> I have two db's, each with a WINNT login named DBATest. DBATest is a member
> of Security Admins as well as db_accessadmin and db_securityadmin in both
> DB's. However, in one DB he can see the Users and Roles, and in the other he
> cant. How can it be?
> TIA, ChrisR

Bizarre login behavior.

sql2k
sp3
I have two db's, each with a WINNT login named DBATest. DBATest is a member
of Security Admins as well as db_accessadmin and db_securityadmin in both
DB's. However, in one DB he can see the Users and Roles, and in the other he
cant. How can it be?
TIA, ChrisRIt turned out to be that Public was granted Select on all the System tables
in one DB but not the other. It would seem that if a user was added to
db_accessadmin and db_securityadmin, something like a trigger would make sur
e
the correct systems tables had Select, but oh well.
"ChrisR" wrote:

> sql2k
> sp3
> I have two db's, each with a WINNT login named DBATest. DBATest is a membe
r
> of Security Admins as well as db_accessadmin and db_securityadmin in both
> DB's. However, in one DB he can see the Users and Roles, and in the other
he
> cant. How can it be?
> TIA, ChrisR