Re: SQL Browser and Online book Questions

The problem lies in the Management Studio Express tool released on November
7. There is a new Management Studio Express CTP download
available at
http://www.microsoft.com/downloads/details.aspx?FamilyId=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en.
This update fixes the defect where installing the full Books Online
documentation prevented Management Studio Express from starting. With
the update, Management Studio Express and Books Online no longer interfere
with each other.

To update Management Studio Express CTP:

1) Uninstall Management Studio Express CTP from your machine.
2) Clear your browser's download cache. If you are using Internet
Explorer 6, you can do this by starting Internet Explorer, clicking the
Tools | Options menu item, and then clicking the "Delete Files..." button
in the "Temporary Internet Files" section.
3) Download and run SQLServer2005_SSMSEE.msi (or
SQLServer2005_SSMSEE_x64.msi) from the URL listed above

If uninstalling and reinstalling Management Studio Express doesn't solve the
problem, then rename (or delete) the
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell
key. This will allow Management Studio Express to run with Books Online,
but will break Management Studio(the full version, not the express version)
if it's also installed.

BTW, the Express BOL only contains topics that are specific to SQL Server
Express. You really need the full Books Online, which is available for
download from here:
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights

"SailFL" <SailFL@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C34E36F1-430A-4C37-952B-064490C02C14@xxxxxxxxxxxxxxxx
> Mike,
>
> Thanks for you explaination on the Browser.
>
> But you made an assumption on BOL. I downloaded and installed the file
> but
> I still can not access the Book On Line. So if I go to Start/programs/MS
> SQL
> Server 2005/Documentation and Tutorials/ and click on SQL Server Express
> Books On LIne, nothing happens. That is my problem. I can not use the
> books
> on line on my computer. Though looking at the one on the web, I am not
> sure
> I am missing much. It doesn't appear to me to be that useful but I would
> still like it to work.
>
> Thanks
> --
> SailFL
>
>
> "Mike Epprecht (SQL MVP)" wrote:
>
>> Hi
>>
>> "SQL Browser" is not a user interface and does not let you look at data.
>> It
>> is a way for instances of SQL Server to automatically announce
>> themselves/list themselves in a service that lets applications find out
>> what
>> SQL Services are running on a machine. This is used applications and not
>> users.
>>
>> BOL does not ship with express. It is available online as you have found.
>>
>> To manage an SQL Server Express edition, you can use the still in beta,
>> Microsoft SQL Server Management Studio Express - Community Technology
>> Preview (CTP) November 2005,
>> http://www.microsoft.com/downloads/details.aspx?FamilyID=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&DisplayLang=en
>>
>> Regards
>> --------------------------------
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>>
>> IM: mike@xxxxxxxxxxxx
>>
>> MVP Program: http://www.microsoft.com/mvp
>>
>> Blog: http://www.msmvps.com/epprecht/
>>
>> "SailFL" <SailFL@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:5E604E61-367C-4C2E-B0E5-5D8E74F7EBDD@xxxxxxxxxxxxxxxx
>> >I have downloaded more recently SQL Server 2005 Express. I am trying to
>> > learn how to use it.
>> >
>> > 1) SQL Browser
>> > I have SSMS (Management Console), I see that I have SQL Server Config
>> > Manager. I would like to use the SQL Browser. Reading in the Online
>> > book
>> > on
>> > the web, I have been able to attach the AdventureWorksDB. I looked for
>> > the
>> > SQL Browser in the Services and Applications in Computer Manager but it
>> > was
>> > not there. I learned how to start the SQL Browser but even after I
>> > started
>> > it, It was not located in Computer Manager.
>> >
>> > How do I use it and how do I get it to appear in Computer Manager? I
>> > am
>> > assuming it open in a separate window.
>> >
>> > 2) Online Book.
>> > I can not access on the Online Book on my computer with out going to
>> > the
>> > web. How do I fix that? Please be explicit.
>> >
>> > Thank your for your assistance.
>> >
>> >
>> >
>> > --
>> > SailFL
>>
>>
>>


.

Loading