Re: \Program Files\Microsoft SQL Server\80?

From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 16:38:28 +0100

hi Shannon,
"Shannon" <Shannon507@aol.com> ha scritto nel messaggio
news:fbae01c40cf2$9ecb5080$a101280a@phx.gbl...
> When installing MSDE onto the d: drive, I still get this
> entry (\Program Files\Microsoft SQL Server\80) installed
> on the c: drive. Within this directory there are two
> additional directories (\Com and \Tools). Is there a way
> to get this directory also installed onto d:; and what is
> in this directory. Are theses things needed for MSDE to
> function.

those are SQL Server components that are shared and common to all instances
installed on the same server, such as SQL-DMO components, the Server Network
Utiliy, oSql.exe.... al the client tools available to MSDE [and they are not
much =:-(( ]
when you install a new service pack, all this components, even if shared
among all instances with different service pack level, will be update to the
new service pack level, for all instances.. 

-- 
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm        http://italy.mvps.org
DbaMgr2k ver 0.6.0  -  DbaMgr ver 0.52.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply
usually the common and shared components of SQL Server are

Relevant Pages

  • Re: How to install service pack 3a on a failover cluster
    ... The steps for installing service pack 3a is documented in the Readme for service pack 3a. ... The following information applies only to SQL Server 2000 components that are part of a failover cluster. ... If any resources have been added with dependencies on SQL Server resources, those dependencies must either be removed or taken offline before you install SP3a. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Basic "getting started" Info on MSDE 2000?
    ... > I am looking for basic info on installing and using MSDE. ... > I am trying to install and play with MSDE on my PC. ... SQL Server runs as a service, and you should start it from the ...
    (comp.databases.ms-sqlserver)
  • Re: Installation OK, but cant connect
    ... tell the person installing to create a user ... >but your MSDE will act as a single desktop database ... edits MSDE, or already have MSDE or SQL Server installed?) ... In what way do I use SQL Server to minimize ...
    (microsoft.public.sqlserver.msde)
  • Re: Post SP2 User/Group Permissions IIS - MDSE/SQL 7 Failure
    ... How Windows XP Service Pack 2 Affects SQL Server and MSDE ... Mike Walsh, Helsinki, Finland ...
    (microsoft.public.sharepoint.teamservices)
  • Re: SQLServerAgent???
    ... >> events in the Event Log, it seems to do something with the network. ... > If both services are 'started', you are running an instance of SQL Server ... > (or MSDE) on your computer. ... > and installing MSDE, then it was installed as part of another application ...
    (microsoft.public.win2000.general)