PredictProbability with Association Rule model..

I have run into a .. somewhat of a "duh" question. I'm running association rule to run a basket analysis, and I'm trying to get probability of each prediction. I know this is wrong, but how do I go about running PredictProbability on each ProductPurchase prediction?

When I run the below DMX query, I get this error message...

Error (Data mining): the dot expression is not allowed in the context at line 5, column 25. Use sub-SELECT instead.

Thanks in advance...

-Young K

SELECT
t.[AgeGroupName]
, t.[ChildrenStatusName]
, (Predict([Basket Analysis AR].[Training Product], 3)) as [ProductPurchases]
, (PredictProbability([Basket Analysis AR].[Training Product].[ProductName])) as [ProductPurchases]
From
[Basket Analysis AR]
PREDICTION JOIN
OPENQUERY([DM Reports DM],
'SELECT
[AgeGroupName]
, [ChildrenStatusName]
FROM
[dbo].[DM.BasketAnalysis.Contact]
WHERE isTrainingData = 0
') AS t
ON
[Basket Analysis AR].[Age Group Name] = t.[AgeGroupName]
AND [Basket Analysis AR].[Children Status Name] = t.[ChildrenStatusName]

You can actually get the statistics directly from the Predict function call:

Note the extra flag for the Predict function (INCLUDE_STATISTICS) and the removal of the PredictProbability call. PredictProbability will not work for nested table columns

SELECT
t.[AgeGroupName]
, t.[ChildrenStatusName]
, (Predict([Basket Analysis AR].[Training Product], INCLUDE_STATISTICS, 3)) as [ProductPurchases]
From
[Basket Analysis AR]
PREDICTION JOIN
OPENQUERY([DM Reports DM],
'SELECT
[AgeGroupName]
, [ChildrenStatusName]
FROM
[dbo].[DM.BasketAnalysis.Contact]
WHERE isTrainingData = 0
') AS t
ON
[Basket Analysis AR].[Age Group Name] = t.[AgeGroupName]
AND [Basket Analysis AR].[Children Status Name] = t.[ChildrenStatusName]

The results results will include the probability/support and adjusted probability for each of the predicted items

|||Thanks so much. :-D

PredictCaseLikelihood

I'm working with the cluster analysis algorithm (EM) in SQL 2005. I have tried to find documentation on the function PredictCaseLikelihood without luck. Is there any reference on how this function is defined?

Here's an excerpt from my book Data Mining with SQL Server 2005

PredictCaseLikelihood

PredictCaseLikelihood returns a measure from 0 to 1 that indicates how likely an input case is to exist considering the model learned by the algorithm.This measure is very good for use in anomaly detection as it quickly and easily tells you if new data is similar to any data seen before.This function operates in two modes, normalized and nonnormalized.

In the nonnormalized mode, the value of the measure is the raw probability of the case, that is, the product of the probabilities of each of the attributes in the case.For instance, if the probability of Home Ownership = ‘Yes’ is 40% and the probability of Occupation = ‘Craftsmen’ is 10% then the probability of the case is 40% x 10% = 4%.

Nonnormalized likelihoods can be useful, but due to the nature of the probabilities, as you increase the number of attributes in a case the probability of the case becomes increasingly small.Additionally, as a user, you can not understand if a 4% probability for a certain combination of attributes is a good thing or a bad thing.The normalized likelihood divides the probability of the case as provided by the model by the probability computed without the model using raw statistics.This provides a “lift” number that is normalized between 0 and 1 using the formula (lift)/(lift + 1).This is interpreted that cases with likelihood values greater than 0.5 have positive lift and are more likely than random to occur and that values less than 0.5 have negative life and are less likely than random to occur.

For continuous attributes, the probability distribution is used for this computation.

This query returns the normalized case likelihood for each case in the input set.

SELECT t.id, PredictCaseLikelihood()

FROM CustomerClusters

NATURAL PREDICTION JOIN <Input Set> AS t

This query returns the nonnormalized case likelihood for each case in the input set.

SELECT t.id, CaseLikelihood(NONNORMALIZED)

FROM CustomerClusters

NATURAL PREDICTION JOIN <Input Set> AS t

Potential conflicts during cluster installs of SS2000 and AS2000

Hi,
Generally, are there any potential problems with installing Analysis
Services on a clustered server that already has SQLServer 2000
installed on multiple virtual servers? I mean in terms of
cross-dependencies between AS2000 and SS2000 with respect to their
functionalities or Service Pack requirements, or even any impacts on
client-side MDAC? Are there any good resources covering this?
In more detail... and where it gets tricky... and apologies for the
length but you will appreciate the need for detail...
I work in a validated environment. We run SS2000 SP1 on the production
cluster and SS2000 SP1 on a 2nd cluster (the 2nd cluster contains 2
validation instances and 1 reporting instance). Both production and
validation would have to be on the same service pack because it is
likely that the re-validation effort required would preclude an
upgrade.
[For those of you who are unfamiliar with the term validation...
Validation is essentially the same as testing, but testing in the
context of a regulated US FDA formal, documented testing regime which
medical device and pharmaceutical companies must adhere to. This puts a
very large and expensive burden on project lifecycles and means that
every change to the software or environment must be assessed as to its
impact on the quality of the system. As you can imagine, nothing gets
changed unless there is a very, very high level of confidence that
everything will be ok.]
Specifically... I have a production instance on 1 cluster. On a second
cluster I have 2 validation instances and 1 reporting instance (hence
AS2000). The applications are all VB6 client/server architecture
(although AS2000 will be a mixture of web and client MMC consoles)
Both machines are 2 node, active/passive clusters running Windows 2003
Server with SAN storage. The production cluster has 1 virtual server
with a SS2000 instance running on it. The second cluster has 3 virtual
servers which each have their own instance (i.e. separate binaries on
the E:\, F:\ and G:\ drives of the underlying single OS.) There are
SS2000 files on the C:\ drive which look like they might be shared -
not sure but they could also be the client tools for SS2000 (any
ideas?).
This is the output from the @.@.version command which is identical on
each of the instances:
"Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005
23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise
Edition on Windows NT 5.2 (Build 3790: Service Pack 1)"
Is it possible to:
1. Install separate service packs on the different instances on the
second cluster, i.e. keeping the 2 validation instances on SP1 and
moving the reporting instance to SP4. Are there any side-effects to
common files, regedit or uninstalling service packs complaining about
shared DLLs on C:\ drive?
2. After installing AS2000 (SP?) on the reporting virtual server on the
second cluster, would the presence of AS2000 on the second cluster
compromise in any way (i) the operation of the validation instances,
(ii) force an upgrade to a higher service pack on SS2000 the validation
instance, (iii) interfere with the way in which client MDAC DLLs
communicate with the validation instance or (iv) compromise an
uninstall scenario?
What makes me wonder about this is there there are a lot of components
and pre-requisites for AS2000. I successfully installed it on my own PC
(XP with MSDE - command line install) and found that the install was
quite intricate. The question is if the installs clearly and cleanly
operate independently of each other in a clustered/virtual server
context.
Any help would be very much appreciated.
Regards
LiamHi
From your @.@.VERSION you are on SQL Server 2000 Service Pack 4, if you are
using AWE then you should really be on version 2040 and this is a very
important fix if you ever need more than 50% of the RAM, if you enviage this
happening it may be worth planning ahead for your regression tests.
The main thing you may be concerned about is the performance impact of the
Analysis services, without performance testing the whole system you will not
know if this will affect performance of the other systems. I assume you have
good benchmarks that you performance criteria and data? From the software
side I don't know of any dependencies, the service packs are certainly
separate and your clients will not be affected. Different instances can run
of different service packs in a clustered environment. Most installations
don't have the executables on the SAN as this can cause a catch 22 situation
if the SAN fails, but you don't say what files are in which location so it is
imposible to know what is common and what is not in your configuration.
HTH
John
"Liam Caffrey" wrote:
> Hi,
> Generally, are there any potential problems with installing Analysis
> Services on a clustered server that already has SQLServer 2000
> installed on multiple virtual servers? I mean in terms of
> cross-dependencies between AS2000 and SS2000 with respect to their
> functionalities or Service Pack requirements, or even any impacts on
> client-side MDAC? Are there any good resources covering this?
> In more detail... and where it gets tricky... and apologies for the
> length but you will appreciate the need for detail...
> I work in a validated environment. We run SS2000 SP1 on the production
> cluster and SS2000 SP1 on a 2nd cluster (the 2nd cluster contains 2
> validation instances and 1 reporting instance). Both production and
> validation would have to be on the same service pack because it is
> likely that the re-validation effort required would preclude an
> upgrade.
> [For those of you who are unfamiliar with the term validation...
> Validation is essentially the same as testing, but testing in the
> context of a regulated US FDA formal, documented testing regime which
> medical device and pharmaceutical companies must adhere to. This puts a
> very large and expensive burden on project lifecycles and means that
> every change to the software or environment must be assessed as to its
> impact on the quality of the system. As you can imagine, nothing gets
> changed unless there is a very, very high level of confidence that
> everything will be ok.]
> Specifically... I have a production instance on 1 cluster. On a second
> cluster I have 2 validation instances and 1 reporting instance (hence
> AS2000). The applications are all VB6 client/server architecture
> (although AS2000 will be a mixture of web and client MMC consoles)
> Both machines are 2 node, active/passive clusters running Windows 2003
> Server with SAN storage. The production cluster has 1 virtual server
> with a SS2000 instance running on it. The second cluster has 3 virtual
> servers which each have their own instance (i.e. separate binaries on
> the E:\, F:\ and G:\ drives of the underlying single OS.) There are
> SS2000 files on the C:\ drive which look like they might be shared -
> not sure but they could also be the client tools for SS2000 (any
> ideas?).
> This is the output from the @.@.version command which is identical on
> each of the instances:
> "Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005
> 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise
> Edition on Windows NT 5.2 (Build 3790: Service Pack 1)"
> Is it possible to:
> 1. Install separate service packs on the different instances on the
> second cluster, i.e. keeping the 2 validation instances on SP1 and
> moving the reporting instance to SP4. Are there any side-effects to
> common files, regedit or uninstalling service packs complaining about
> shared DLLs on C:\ drive?
> 2. After installing AS2000 (SP?) on the reporting virtual server on the
> second cluster, would the presence of AS2000 on the second cluster
> compromise in any way (i) the operation of the validation instances,
> (ii) force an upgrade to a higher service pack on SS2000 the validation
> instance, (iii) interfere with the way in which client MDAC DLLs
> communicate with the validation instance or (iv) compromise an
> uninstall scenario?
> What makes me wonder about this is there there are a lot of components
> and pre-requisites for AS2000. I successfully installed it on my own PC
> (XP with MSDE - command line install) and found that the install was
> quite intricate. The question is if the installs clearly and cleanly
> operate independently of each other in a clustered/virtual server
> context.
> Any help would be very much appreciated.
> Regards
> Liam
>|||Yes, you are right... SP4 and yes, that hotfix is important especially
after we ordered extra RAM for the machine to bring it up to 8GB!!
SS2000 SP4 simplifies the whole thing... the question now is can the
installation of AS2000 affect in any way the installed SS2000 SP4 files
that reside outside of the virtual servers , i.e. on the C:\ with the
OS. I attach the directory listing?
(BTW, I am assuming that any SS2000 files inside the virtual servers
will not be affected. Is this correct? )
>From this posting it looks like the answer might be yes... this person
had a problem installing SP4 on a multi-instance 2003 server...
http://groups.google.ie/group/microsoft.public.sqlserver.setup/browse_frm/thread/cc58d69e4ad1524/98ec03c19d001c99?lnk=st&q=msxmlsql.dll+-failed&rnum=4&hl=en#98ec03c19d001c99
It wouldn't let him write to a shared file that is listed below
(msxmlsql.rll) during the application of SP4 while the second instance
was running. What was it trying to write? Would the same happen with
AS2000 install or the hotfix? This is precisely what I am trying to
figure out. What is the impact of whatever is written?
This is the current directory for the listing:
C:\Program Files\Microsoft SQL Server
Do anything here stand out? (We don't use replication or log shipping -
just backup log/copy/restore jobs)
Thanks for your help...
Liam
.\80
.\80\COM
.\80\Shared
.\80\Tools
.\80\COM\1033
.\80\COM\distrib.exe
.\80\COM\dw15.exe
.\80\COM\impprov.dll
.\80\COM\logread.exe
.\80\COM\mergetxt.dll
.\80\COM\msgprox.dll
.\80\COM\Other
.\80\COM\qrdrsvc.exe
.\80\COM\rdistcom.dll
.\80\COM\replagnt.dll
.\80\COM\repldist.dll
.\80\COM\repldp.dll
.\80\COM\repldsui.dll
.\80\COM\repldts.dll
.\80\COM\replerrx.dll
.\80\COM\replmerg.exe
.\80\COM\replprov.dll
.\80\COM\replprox.dll
.\80\COM\replrec.dll
.\80\COM\replsub.dll
.\80\COM\replsync.dll
.\80\COM\Resources
.\80\COM\rinitcom.dll
.\80\COM\snapshot.exe
.\80\COM\spresolv.dll
.\80\COM\sqldistx.dll
.\80\COM\sqldumper.exe
.\80\COM\sqlfth75.dll
.\80\COM\sqlinitx.dll
.\80\COM\sqlmergx.dll
.\80\COM\sqlresld.dll
.\80\COM\sqlvdi.dll
.\80\COM\ssradd.dll
.\80\COM\ssravg.dll
.\80\COM\ssrdown.dll
.\80\COM\ssrmax.dll
.\80\COM\ssrmin.dll
.\80\COM\ssrpub.dll
.\80\COM\ssrup.dll
.\80\COM\1033\dwintl.dll
.\80\COM\Other\dwintl.dll
.\80\COM\Resources\1033
.\80\COM\Resources\1033\replres.rll
.\80\Shared\msxmlsql.dll
.\80\Shared\Resources
.\80\Shared\Resources\1033
.\80\Shared\Resources\1033\msxmlsql.rll
.\80\Tools\Binn
.\80\Tools\Books
.\80\Tools\DevTools
.\80\Tools\HTML
.\80\Tools\Install
.\80\Tools\Scripts
.\80\Tools\sqlsun.dll
.\80\Tools\sqlsunin.ini
.\80\Tools\Templates
.\80\Tools\Uninst.isu
.\80\Tools\Binn\autoplt.dll
.\80\Tools\Binn\autowiz.dll
.\80\Tools\Binn\axscphst.dll
.\80\Tools\Binn\bcp.exe
.\80\Tools\Binn\cdw.exe
.\80\Tools\Binn\cdwtasks.dll
.\80\Tools\Binn\cdwtskui.dll
.\80\Tools\Binn\cnfgsvr.exe
.\80\Tools\Binn\cnfgsvr.ini
.\80\Tools\Binn\colctrl.dll
.\80\Tools\Binn\comnevnt.dll
.\80\Tools\Binn\ctasksui.dll
.\80\Tools\Binn\custtask.dll
.\80\Tools\Binn\dcomscm.exe
.\80\Tools\Binn\dtsffile.dll
.\80\Tools\Binn\dtspkg.dll
.\80\Tools\Binn\dtspump.dll
.\80\Tools\Binn\dtsrun.exe
.\80\Tools\Binn\dtsrunui.exe
.\80\Tools\Binn\dtsui.dll
.\80\Tools\Binn\dtswiz.dll
.\80\Tools\Binn\dtswiz.exe
.\80\Tools\Binn\hhsetup.dll
.\80\Tools\Binn\isql.exe
.\80\Tools\Binn\isqlw.exe
.\80\Tools\Binn\itwiz.exe
.\80\Tools\Binn\objmgr.dll
.\80\Tools\Binn\objmgr80.xml
.\80\Tools\Binn\odbccmpt.exe
.\80\Tools\Binn\osql.exe
.\80\Tools\Binn\pfclnt80.dll
.\80\Tools\Binn\pfutil80.dll
.\80\Tools\Binn\profiler.exe
.\80\Tools\Binn\psdcscm.dll
.\80\Tools\Binn\rebuildm.exe
.\80\Tools\Binn\replmon.pmc
.\80\Tools\Binn\Resources
.\80\Tools\Binn\scm.exe
.\80\Tools\Binn\sdiclnt.dll
.\80\Tools\Binn\semcomn.dll
.\80\Tools\Binn\semcros.dll
.\80\Tools\Binn\semdll.dll
.\80\Tools\Binn\semdts.dll
.\80\Tools\Binn\semexec.dll
.\80\Tools\Binn\semmap.dll
.\80\Tools\Binn\semnt.dll
.\80\Tools\Binn\semobj.dll
.\80\Tools\Binn\semrepl.dll
.\80\Tools\Binn\semsfc.dll
.\80\Tools\Binn\semsys.dll
.\80\Tools\Binn\semwebwz.dll
.\80\Tools\Binn\semwiz.dll
.\80\Tools\Binn\sqdedev.dll
.\80\Tools\Binn\sql iis admin.msc
.\80\Tools\Binn\SQL Server Enterprise Manager.MSC
.\80\Tools\Binn\sqladhlp.exe
.\80\Tools\Binn\sqlbrows.cnt
.\80\Tools\Binn\sqlbrows.hlp
.\80\Tools\Binn\sqldmo.dll
.\80\Tools\Binn\sqldmo80.cnt
.\80\Tools\Binn\sqldmo80.hlp
.\80\Tools\Binn\sqldts80.cnt
.\80\Tools\Binn\sqldts80.hlp
.\80\Tools\Binn\sqlftwiz.dll
.\80\Tools\Binn\sqlftwiz.exe
.\80\Tools\Binn\sqlgui.dll
.\80\Tools\Binn\sqllex.dll
.\80\Tools\Binn\sqlmangr.exe
.\80\Tools\Binn\sqlmmc.dll
.\80\Tools\Binn\sqlmmcem.chm
.\80\Tools\Binn\sqlmmcii.chm
.\80\Tools\Binn\sqlns.dll
.\80\Tools\Binn\sqlns80.cnt
.\80\Tools\Binn\sqlns80.hlp
.\80\Tools\Binn\sqlqry.dll
.\80\Tools\Binn\sqlresld.dll
.\80\Tools\Binn\sqlslic.cpl
.\80\Tools\Binn\sqlsui.dll
.\80\Tools\Binn\sqlsun.dll
.\80\Tools\Binn\sqlsvc.dll
.\80\Tools\Binn\sqlvdir.dll
.\80\Tools\Binn\stardds.dll
.\80\Tools\Binn\svrnetcn.dll
.\80\Tools\Binn\svrnetcn.exe
.\80\Tools\Binn\uncol.exe
.\80\Tools\Binn\w95scm.dll
.\80\Tools\Binn\wiztrace.exe
.\80\Tools\Binn\Resources\1033
.\80\Tools\Binn\Resources\1033\autoplt.rll
.\80\Tools\Binn\Resources\1033\autowiz.rll
.\80\Tools\Binn\Resources\1033\axscphst.rll
.\80\Tools\Binn\Resources\1033\bcp.rll
.\80\Tools\Binn\Resources\1033\cdw.rll
.\80\Tools\Binn\Resources\1033\cdwtasks.rll
.\80\Tools\Binn\Resources\1033\cdwtskui.rll
.\80\Tools\Binn\Resources\1033\ctasksui.rll
.\80\Tools\Binn\Resources\1033\custtask.rll
.\80\Tools\Binn\Resources\1033\dtsffile.rll
.\80\Tools\Binn\Resources\1033\dtspkg.rll
.\80\Tools\Binn\Resources\1033\dtspump.rll
.\80\Tools\Binn\Resources\1033\dtsrun.rll
.\80\Tools\Binn\Resources\1033\dtsrunui.rll
.\80\Tools\Binn\Resources\1033\dtsui.rll
.\80\Tools\Binn\Resources\1033\dtswiz.rll
.\80\Tools\Binn\Resources\1033\isqlw.rll
.\80\Tools\Binn\Resources\1033\itwiz.rll
.\80\Tools\Binn\Resources\1033\objmgr.rll
.\80\Tools\Binn\Resources\1033\pfclnt80.rll
.\80\Tools\Binn\Resources\1033\pfutil80.rll
.\80\Tools\Binn\Resources\1033\profiler.rll
.\80\Tools\Binn\Resources\1033\rebuildm.rll
.\80\Tools\Binn\Resources\1033\semcomn.rll
.\80\Tools\Binn\Resources\1033\semcros.rll
.\80\Tools\Binn\Resources\1033\semdll.rll
.\80\Tools\Binn\Resources\1033\semdts.rll
.\80\Tools\Binn\Resources\1033\semexec.rll
.\80\Tools\Binn\Resources\1033\semmap.rll
.\80\Tools\Binn\Resources\1033\semnt.rll
.\80\Tools\Binn\Resources\1033\semobj.rll
.\80\Tools\Binn\Resources\1033\semrepl.rll
.\80\Tools\Binn\Resources\1033\semsfc.rll
.\80\Tools\Binn\Resources\1033\semsys.rll
.\80\Tools\Binn\Resources\1033\semwebwz.rll
.\80\Tools\Binn\Resources\1033\semwiz.rll
.\80\Tools\Binn\Resources\1033\sqladevn.rll
.\80\Tools\Binn\Resources\1033\sqldmo.rll
.\80\Tools\Binn\Resources\1033\sqlftwiz.rll
.\80\Tools\Binn\Resources\1033\sqlgui.rll
.\80\Tools\Binn\Resources\1033\sqlmangr.rll
.\80\Tools\Binn\Resources\1033\sqlmmc.rll
.\80\Tools\Binn\Resources\1033\sqlns.rll
.\80\Tools\Binn\Resources\1033\sqlqry.rll
.\80\Tools\Binn\Resources\1033\sqlsui.rll
.\80\Tools\Binn\Resources\1033\sqlsvc.rll
.\80\Tools\Binn\Resources\1033\sqlvdir.rll
.\80\Tools\Binn\Resources\1033\svrnetcn.rll
.\80\Tools\Binn\Resources\1033\wiztrace.rll
.\80\Tools\Books\acdata.chi
.\80\Tools\Books\acdata.chm
.\80\Tools\Books\adminsql.chi
.\80\Tools\Books\adminsql.chm
.\80\Tools\Books\adosql.chi
.\80\Tools\Books\adosql.chm
.\80\Tools\Books\architec.chi
.\80\Tools\Books\architec.chm
.\80\Tools\Books\bldgapps.chi
.\80\Tools\Books\bldgapps.chm
.\80\Tools\Books\coprompt.chi
.\80\Tools\Books\coprompt.chm
.\80\Tools\Books\createdb.chi
.\80\Tools\Books\createdb.chm
.\80\Tools\Books\createdw.chi
.\80\Tools\Books\createdw.chm
.\80\Tools\Books\dblibc.chi
.\80\Tools\Books\dblibc.chm
.\80\Tools\Books\dbmigwiz.chi
.\80\Tools\Books\dbmigwiz.chm
.\80\Tools\Books\dbmntwiz.chi
.\80\Tools\Books\dbmntwiz.chm
.\80\Tools\Books\distsql.chi
.\80\Tools\Books\distsql.chm
.\80\Tools\Books\dtsdsgnr.chi
.\80\Tools\Books\dtsdsgnr.chm
.\80\Tools\Books\dtsprog.chi
.\80\Tools\Books\dtsprog.chm
.\80\Tools\Books\dtsrunui.chi
.\80\Tools\Books\dtsrunui.chm
.\80\Tools\Books\dtssql.chi
.\80\Tools\Books\dtssql.chm
.\80\Tools\Books\dtswizrd.chi
.\80\Tools\Books\dtswizrd.chm
.\80\Tools\Books\entrmgr.chi
.\80\Tools\Books\entrmgr.chm
.\80\Tools\Books\eqbol.chi
.\80\Tools\Books\eqbol.chm
.\80\Tools\Books\esqlforc.chi
.\80\Tools\Books\esqlforc.chm
.\80\Tools\Books\fulltxt.chi
.\80\Tools\Books\fulltxt.chm
.\80\Tools\Books\glossary.chi
.\80\Tools\Books\glossary.chm
.\80\Tools\Books\hlpview.chi
.\80\Tools\Books\hlpview.chm
.\80\Tools\Books\howtosql.chi
.\80\Tools\Books\howtosql.chm
.\80\Tools\Books\iisadmin.chi
.\80\Tools\Books\iisadmin.chm
.\80\Tools\Books\indextun.chi
.\80\Tools\Books\indextun.chm
.\80\Tools\Books\instsql.chi
.\80\Tools\Books\instsql.chm
.\80\Tools\Books\mdacxml.chi
.\80\Tools\Books\mdacxml.chm
.\80\Tools\Books\netconf.chi
.\80\Tools\Books\netconf.chm
.\80\Tools\Books\odbcsql.chi
.\80\Tools\Books\odbcsql.chm
.\80\Tools\Books\odssql.chi
.\80\Tools\Books\odssql.chm
.\80\Tools\Books\olapdmad.chi
.\80\Tools\Books\olapdmad.chm
.\80\Tools\Books\olapdmpr.chi
.\80\Tools\Books\olapdmpr.chm
.\80\Tools\Books\oledbsql.chi
.\80\Tools\Books\oledbsql.chm
.\80\Tools\Books\optimsql.chi
.\80\Tools\Books\optimsql.chm
.\80\Tools\Books\profiler.chi
.\80\Tools\Books\profiler.chm
.\80\Tools\Books\qryanlzr.chi
.\80\Tools\Books\qryanlzr.chm
.\80\Tools\Books\rebldmst.chi
.\80\Tools\Books\rebldmst.chm
.\80\Tools\Books\repconf.chi
.\80\Tools\Books\repconf.chm
.\80\Tools\Books\replprog.chi
.\80\Tools\Books\replprog.chm
.\80\Tools\Books\replsql.chi
.\80\Tools\Books\replsql.chm
.\80\Tools\Books\reposad.chi
.\80\Tools\Books\reposad.chm
.\80\Tools\Books\repospr.chi
.\80\Tools\Books\repospr.chm
.\80\Tools\Books\repsync.chi
.\80\Tools\Books\repsync.chm
.\80\Tools\Books\repwizrd.chi
.\80\Tools\Books\repwizrd.chm
.\80\Tools\Books\samples.chi
.\80\Tools\Books\samples.chm
.\80\Tools\Books\setupsql.chm
.\80\Tools\Books\sql80.chs
.\80\Tools\Books\SQL80.chw
.\80\Tools\Books\sql80.col
.\80\Tools\Books\sqldmo.chi
.\80\Tools\Books\sqldmo.chm
.\80\Tools\Books\sqlns.chi
.\80\Tools\Books\sqlns.chm
.\80\Tools\Books\startsql.chi
.\80\Tools\Books\startsql.chm
.\80\Tools\Books\trblsql.chi
.\80\Tools\Books\trblsql.chm
.\80\Tools\Books\tsqlref.chi
.\80\Tools\Books\tsqlref.chm
.\80\Tools\Books\uiref.chi
.\80\Tools\Books\uiref.chm
.\80\Tools\Books\usetools.chi
.\80\Tools\Books\usetools.chm
.\80\Tools\Books\vdtsql.chi
.\80\Tools\Books\vdtsql.chm
.\80\Tools\Books\whatsnew.chi
.\80\Tools\Books\whatsnew.chm
.\80\Tools\Books\xmlref.chi
.\80\Tools\Books\xmlref.chm
.\80\Tools\Books\xmlsql.chi
.\80\Tools\Books\xmlsql.chm
.\80\Tools\DevTools\Include
.\80\Tools\DevTools\Lib
.\80\Tools\DevTools\Include\wn95scm.h
.\80\Tools\DevTools\Lib\w95scm.lib
.\80\Tools\HTML\alrtfdbk.htm
.\80\Tools\HTML\blutop.gif
.\80\Tools\HTML\clustindex.gif
.\80\Tools\HTML\database.css
.\80\Tools\HTML\database.htm
.\80\Tools\HTML\dbback.gif
.\80\Tools\HTML\dbcindex.gif
.\80\Tools\HTML\dbgeneral.html
.\80\Tools\HTML\dbicon.gif
.\80\Tools\HTML\dbindex.gif
.\80\Tools\HTML\dbsymb01.gif
.\80\Tools\HTML\dbsymb02.gif
.\80\Tools\HTML\dbsymb03.gif
.\80\Tools\HTML\dbtable.gif
.\80\Tools\HTML\first.gif
.\80\Tools\HTML\frontcap.gif
.\80\Tools\HTML\go1.gif
.\80\Tools\HTML\go2.gif
.\80\Tools\HTML\godown1.gif
.\80\Tools\HTML\godown2.gif
.\80\Tools\HTML\godownmiddle.gif
.\80\Tools\HTML\gomiddle.gif
.\80\Tools\HTML\grayspace.gif
.\80\Tools\HTML\img00007.gif
.\80\Tools\HTML\img00008.gif
.\80\Tools\HTML\index.gif
.\80\Tools\HTML\js00001.js
.\80\Tools\HTML\js00002.js
.\80\Tools\HTML\js00003.js
.\80\Tools\HTML\jsconst.js
.\80\Tools\HTML\jsmainmenu.js
.\80\Tools\HTML\last.gif
.\80\Tools\HTML\legend.html
.\80\Tools\HTML\ltbtncap.gif
.\80\Tools\HTML\menubottom.gif
.\80\Tools\HTML\menumiddle.gif
.\80\Tools\HTML\menutop.gif
.\80\Tools\HTML\next.gif
.\80\Tools\HTML\panly01.gif
.\80\Tools\HTML\panly02.gif
.\80\Tools\HTML\panly03.gif
.\80\Tools\HTML\previous.gif
.\80\Tools\HTML\redspace.gif
.\80\Tools\HTML\rtbtncap.gif
.\80\Tools\HTML\server.html
.\80\Tools\HTML\servernodeframe.htm
.\80\Tools\HTML\serversymb01.gif
.\80\Tools\HTML\serversymb02.gif
.\80\Tools\HTML\serversymb03.gif
.\80\Tools\HTML\servertabs.htm
.\80\Tools\HTML\sqlhtml.css
.\80\Tools\HTML\sqlmenus.js
.\80\Tools\HTML\sspat.htm
.\80\Tools\HTML\sspat0.htm
.\80\Tools\HTML\sstabs.htm
.\80\Tools\HTML\table.gif
.\80\Tools\HTML\tablego.gif
.\80\Tools\HTML\tableindexframe.html
.\80\Tools\HTML\tablesindex.html
.\80\Tools\HTML\tabs.html
.\80\Tools\HTML\whitecap.gif
.\80\Tools\HTML\wizardbullet.gif
.\80\Tools\HTML\wizards.html
.\80\Tools\HTML\wizbuttbottom.gif
.\80\Tools\HTML\wizbuttmiddle.gif
.\80\Tools\HTML\wizbutttop.gif
.\80\Tools\HTML\wttop.gif
.\80\Tools\Install\setup.iss
.\80\Tools\Scripts\sp_mshasdbaccess65.sql
.\80\Tools\Scripts\sp_mshasdbaccess70.sql
.\80\Tools\Scripts\sp_mshasdbaccess80.sql
.\80\Tools\Scripts\sp_msobjsearch70.sql
.\80\Tools\Scripts\sp_msobjsearch80.sql
.\80\Tools\Templates\DTS
.\80\Tools\Templates\SQL Profiler
.\80\Tools\Templates\SQL Query Analyzer
.\80\Tools\Templates\DTS\Template Demo.dtt
.\80\Tools\Templates\SQL Profiler\SQLProfilerSP_Counts.tdf
.\80\Tools\Templates\SQL Profiler\SQLProfilerStandard.tdf
.\80\Tools\Templates\SQL Profiler\SQLProfilerTSQL.tdf
.\80\Tools\Templates\SQL Profiler\SQLProfilerTSQL_Duration.tdf
.\80\Tools\Templates\SQL Profiler\SQLProfilerTSQL_Grouped.tdf
.\80\Tools\Templates\SQL Profiler\SQLProfilerTSQL_Replay.tdf
.\80\Tools\Templates\SQL Profiler\SQLProfilerTSQL_SPs.tdf
.\80\Tools\Templates\SQL Profiler\SQLProfilerTuning.tdf
.\80\Tools\Templates\SQL Query Analyzer\Attach and Detach Database
.\80\Tools\Templates\SQL Query Analyzer\Create Database
.\80\Tools\Templates\SQL Query Analyzer\Create Function
.\80\Tools\Templates\SQL Query Analyzer\Create Index
.\80\Tools\Templates\SQL Query Analyzer\Create Procedure
.\80\Tools\Templates\SQL Query Analyzer\Create Statistics
.\80\Tools\Templates\SQL Query Analyzer\Create Table
.\80\Tools\Templates\SQL Query Analyzer\Create Trigger
.\80\Tools\Templates\SQL Query Analyzer\Create View
.\80\Tools\Templates\SQL Query Analyzer\Manage Extended Property
.\80\Tools\Templates\SQL Query Analyzer\Manage Linked Server
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User
.\80\Tools\Templates\SQL Query Analyzer\Using Cursor
.\80\Tools\Templates\SQL Query Analyzer\Attach and Detach
Database\Attach_Database_Template.tql
.\80\Tools\Templates\SQL Query Analyzer\Attach and Detach
Database\Attach_Single_File_Database_Template.tql
.\80\Tools\Templates\SQL Query Analyzer\Attach and Detach
Database\Detach_Database_Template.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Database\Create Database
Basic Template.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Database\Create Database
for ATTACH.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Database\Create Database
on Mulitple File Groups.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Database\Create Database
on Multiple Data and Transaction Log Files.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Database\Create Database
Specifying Collation.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Function\Create Inline
Function.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Function\Create Scalar
Function.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Function\Create Table
Function.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Index\Create Index
Basic.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Index\Create Index Full
Syntax.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Procedure\Create
Procedure Basic Template.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Procedure\Create
Procedure with CURSOR OUTPUT Parameter.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Procedure\Create
Procedure with OUTPUT Parameter.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Statistics\Create
Statistics Template.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Table\Create Table Basic
Template.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Table\Create Table
Specifying Constrains.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Table\Create Table
Specifying File Groups.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Table\Create Table with
Computed Column.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Table\Create Table with
IDENTITY Column.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Table\Create Table with
ROWGUIDCOL Column.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Table\Create Temp
Table.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Trigger\Create INSTEAD
OF Trigger Basic Template.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Trigger\Create Trigger
Basic Template.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Trigger\Create Trigger
Contained IF COLUMNS_UPDATED.tql
.\80\Tools\Templates\SQL Query Analyzer\Create Trigger\Create Trigger
Contained IF UPDATE.tql
.\80\Tools\Templates\SQL Query Analyzer\Create View\Create View Basic
Template.tql
.\80\Tools\Templates\SQL Query Analyzer\Create View\Create View with
CHECK OPTION.tql
.\80\Tools\Templates\SQL Query Analyzer\Create View\Create View with
SCHEMABINDING.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Extended Property\Add
Extended Property.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Extended Property\Drop
Extended Property.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Extended Property\List
Extented Property.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Extended Property\Update
Extended Property.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Linked Server\Add Linked
Server Login.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Linked Server\Add
non-Sql Server as Linked Server.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Linked Server\Add Sql
Server as Linked Server.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Linked Server\Configure
Linked Server.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Linked Server\Drop
Linked Server Login.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Linked Server\Drop
Linked Server.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Add
Login to Server Role.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Add Sql
Server Login.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Add User
to Database Role.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Deny Sql
Server Access to Windows User or Group.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Drop
Login from Server Role.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Drop Sql
Server Login.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Drop
User from Database Role.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Grant
Database Access to Windows User or Sql Server Login.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Grant
Sql Server Access to Windows User or Group.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Revoke
Database Access From Windows User or Sql Server Login.tql
.\80\Tools\Templates\SQL Query Analyzer\Manage Login Role User\Revoke
Sql Server Access from Windows User or Group.tql
.\80\Tools\Templates\SQL Query Analyzer\Using Cursor\Declare and Use
KEYSET Cursor.tql
.\80\Tools\Templates\SQL Query Analyzer\Using Cursor\Declare and Use
READ_ONLY Cursor.tql
.\80\Tools\Templates\SQL Query Analyzer\Using Cursor\Declare and Use
SCROLL Cursor with Various FETCH Options.tql
.\80\Tools\Templates\SQL Query Analyzer\Using Cursor\Declare and Use
UPDATE Cursor.tql|||Hi Liam
The files listed are not a full install, on the other drives you will have
copies of sqlserve.exe! As your Database engine is already on SP4 I am not
sure if your original question is an issue? The problem may occur if you have
two live instances running on the same server, failing over so you are only
upgrading the one live on that server would (hopefully) avoid this.
Installing AS SP 4 requires you to failover to the given node before the
upgrade see http://tinyurl.com/ycsjxc
John
"liam.caffrey@.gmail.com" wrote:
> Yes, you are right... SP4 and yes, that hotfix is important especially
> after we ordered extra RAM for the machine to bring it up to 8GB!!
> SS2000 SP4 simplifies the whole thing... the question now is can the
> installation of AS2000 affect in any way the installed SS2000 SP4 files
> that reside outside of the virtual servers , i.e. on the C:\ with the
> OS. I attach the directory listing?
> (BTW, I am assuming that any SS2000 files inside the virtual servers
> will not be affected. Is this correct? )
> >From this posting it looks like the answer might be yes... this person
> had a problem installing SP4 on a multi-instance 2003 server...
> http://groups.google.ie/group/microsoft.public.sqlserver.setup/browse_frm/thread/cc58d69e4ad1524/98ec03c19d001c99?lnk=st&q=msxmlsql.dll+-failed&rnum=4&hl=en#98ec03c19d001c99
> It wouldn't let him write to a shared file that is listed below
> (msxmlsql.rll) during the application of SP4 while the second instance
> was running. What was it trying to write? Would the same happen with
> AS2000 install or the hotfix? This is precisely what I am trying to
> figure out. What is the impact of whatever is written?
> This is the current directory for the listing:
> C:\Program Files\Microsoft SQL Server
> Do anything here stand out? (We don't use replication or log shipping -
> just backup log/copy/restore jobs)
> Thanks for your help...
> Liam
> ..\80
> ..\80\COM
> ..\80\Shared
> ..\80\Tools
> ..\80\COM\1033
> ..\80\COM\distrib.exe
> ..\80\COM\dw15.exe
> ..\80\COM\impprov.dll
> ..\80\COM\logread.exe
> ..\80\COM\mergetxt.dll
> ..\80\COM\msgprox.dll
> ..\80\COM\Other
> ..\80\COM\qrdrsvc.exe
> ..\80\COM\rdistcom.dll
> ..\80\COM\replagnt.dll
> ..\80\COM\repldist.dll
> ..\80\COM\repldp.dll
> ..\80\COM\repldsui.dll
> ..\80\COM\repldts.dll
> ..\80\COM\replerrx.dll
> ..\80\COM\replmerg.exe
> ..\80\COM\replprov.dll
> ..\80\COM\replprox.dll
> ..\80\COM\replrec.dll
> ..\80\COM\replsub.dll
> ..\80\COM\replsync.dll
> ..\80\COM\Resources
> ..\80\COM\rinitcom.dll
> ..\80\COM\snapshot.exe
> ..\80\COM\spresolv.dll
> ..\80\COM\sqldistx.dll
> ..\80\COM\sqldumper.exe
> ..\80\COM\sqlfth75.dll
> ..\80\COM\sqlinitx.dll
> ..\80\COM\sqlmergx.dll
> ..\80\COM\sqlresld.dll
> ..\80\COM\sqlvdi.dll
> ..\80\COM\ssradd.dll
> ..\80\COM\ssravg.dll
> ..\80\COM\ssrdown.dll
> ..\80\COM\ssrmax.dll
> ..\80\COM\ssrmin.dll
> ..\80\COM\ssrpub.dll
> ..\80\COM\ssrup.dll
> ..\80\COM\1033\dwintl.dll
> ..\80\COM\Other\dwintl.dll
> ..\80\COM\Resources\1033
> ..\80\COM\Resources\1033\replres.rll
> ..\80\Shared\msxmlsql.dll
> ..\80\Shared\Resources
> ..\80\Shared\Resources\1033
> ..\80\Shared\Resources\1033\msxmlsql.rll
> ..\80\Tools\Binn
> ..\80\Tools\Books
> ..\80\Tools\DevTools
> ..\80\Tools\HTML
> ..\80\Tools\Install
> ..\80\Tools\Scripts
> ..\80\Tools\sqlsun.dll
> ..\80\Tools\sqlsunin.ini
> ..\80\Tools\Templates
> ..\80\Tools\Uninst.isu
> ..\80\Tools\Binn\autoplt.dll
> ..\80\Tools\Binn\autowiz.dll
> ..\80\Tools\Binn\axscphst.dll
> ..\80\Tools\Binn\bcp.exe
> ..\80\Tools\Binn\cdw.exe
> ..\80\Tools\Binn\cdwtasks.dll
> ..\80\Tools\Binn\cdwtskui.dll
> ..\80\Tools\Binn\cnfgsvr.exe
> ..\80\Tools\Binn\cnfgsvr.ini
> ..\80\Tools\Binn\colctrl.dll
> ..\80\Tools\Binn\comnevnt.dll
> ..\80\Tools\Binn\ctasksui.dll
> ..\80\Tools\Binn\custtask.dll
> ..\80\Tools\Binn\dcomscm.exe
> ..\80\Tools\Binn\dtsffile.dll
> ..\80\Tools\Binn\dtspkg.dll
> ..\80\Tools\Binn\dtspump.dll
> ..\80\Tools\Binn\dtsrun.exe
> ..\80\Tools\Binn\dtsrunui.exe
> ..\80\Tools\Binn\dtsui.dll
> ..\80\Tools\Binn\dtswiz.dll
> ..\80\Tools\Binn\dtswiz.exe
> ..\80\Tools\Binn\hhsetup.dll
> ..\80\Tools\Binn\isql.exe
> ..\80\Tools\Binn\isqlw.exe
> ..\80\Tools\Binn\itwiz.exe
> ..\80\Tools\Binn\objmgr.dll
> ..\80\Tools\Binn\objmgr80.xml
> ..\80\Tools\Binn\odbccmpt.exe
> ..\80\Tools\Binn\osql.exe
> ..\80\Tools\Binn\pfclnt80.dll
> ..\80\Tools\Binn\pfutil80.dll
> ..\80\Tools\Binn\profiler.exe
> ..\80\Tools\Binn\psdcscm.dll
> ..\80\Tools\Binn\rebuildm.exe
> ..\80\Tools\Binn\replmon.pmc
> ..\80\Tools\Binn\Resources
> ..\80\Tools\Binn\scm.exe
> ..\80\Tools\Binn\sdiclnt.dll
> ..\80\Tools\Binn\semcomn.dll
> ..\80\Tools\Binn\semcros.dll
> ..\80\Tools\Binn\semdll.dll
> ..\80\Tools\Binn\semdts.dll
> ..\80\Tools\Binn\semexec.dll
> ..\80\Tools\Binn\semmap.dll
> ..\80\Tools\Binn\semnt.dll
> ..\80\Tools\Binn\semobj.dll
> ..\80\Tools\Binn\semrepl.dll
> ..\80\Tools\Binn\semsfc.dll
> ..\80\Tools\Binn\semsys.dll
> ..\80\Tools\Binn\semwebwz.dll
> ..\80\Tools\Binn\semwiz.dll
> ..\80\Tools\Binn\sqdedev.dll
> ..\80\Tools\Binn\sql iis admin.msc
> ..\80\Tools\Binn\SQL Server Enterprise Manager.MSC
> ..\80\Tools\Binn\sqladhlp.exe
> ..\80\Tools\Binn\sqlbrows.cnt
> ..\80\Tools\Binn\sqlbrows.hlp
> ..\80\Tools\Binn\sqldmo.dll
> ..\80\Tools\Binn\sqldmo80.cnt
> ..\80\Tools\Binn\sqldmo80.hlp
> ..\80\Tools\Binn\sqldts80.cnt
> ..\80\Tools\Binn\sqldts80.hlp
> ..\80\Tools\Binn\sqlftwiz.dll
> ..\80\Tools\Binn\sqlftwiz.exe
> ..\80\Tools\Binn\sqlgui.dll
> ..\80\Tools\Binn\sqllex.dll
> ..\80\Tools\Binn\sqlmangr.exe
> ..\80\Tools\Binn\sqlmmc.dll
> ..\80\Tools\Binn\sqlmmcem.chm
> ..\80\Tools\Binn\sqlmmcii.chm
> ..\80\Tools\Binn\sqlns.dll
> ..\80\Tools\Binn\sqlns80.cnt
> ..\80\Tools\Binn\sqlns80.hlp
> ..\80\Tools\Binn\sqlqry.dll
> ..\80\Tools\Binn\sqlresld.dll
> ..\80\Tools\Binn\sqlslic.cpl
> ..\80\Tools\Binn\sqlsui.dll
> ..\80\Tools\Binn\sqlsun.dll
> ..\80\Tools\Binn\sqlsvc.dll
> ..\80\Tools\Binn\sqlvdir.dll
> ..\80\Tools\Binn\stardds.dll
> ..\80\Tools\Binn\svrnetcn.dll
> ..\80\Tools\Binn\svrnetcn.exe
> ..\80\Tools\Binn\uncol.exe
> ..\80\Tools\Binn\w95scm.dll
> ..\80\Tools\Binn\wiztrace.exe
> ..\80\Tools\Binn\Resources\1033
> ..\80\Tools\Binn\Resources\1033\autoplt.rll
> ..\80\Tools\Binn\Resources\1033\autowiz.rll
> ..\80\Tools\Binn\Resources\1033\axscphst.rll
> ..\80\Tools\Binn\Resources\1033\bcp.rll
> ..\80\Tools\Binn\Resources\1033\cdw.rll
> ..\80\Tools\Binn\Resources\1033\cdwtasks.rll
> ..\80\Tools\Binn\Resources\1033\cdwtskui.rll
> ..\80\Tools\Binn\Resources\1033\ctasksui.rll
> ..\80\Tools\Binn\Resources\1033\custtask.rll
> ..\80\Tools\Binn\Resources\1033\dtsffile.rll
> ..\80\Tools\Binn\Resources\1033\dtspkg.rll
> ..\80\Tools\Binn\Resources\1033\dtspump.rll
> ..\80\Tools\Binn\Resources\1033\dtsrun.rll
> ..\80\Tools\Binn\Resources\1033\dtsrunui.rll
> ..\80\Tools\Binn\Resources\1033\dtsui.rll
> ..\80\Tools\Binn\Resources\1033\dtswiz.rll
> ..\80\Tools\Binn\Resources\1033\isqlw.rll
> ..\80\Tools\Binn\Resources\1033\itwiz.rll
> ..\80\Tools\Binn\Resources\1033\objmgr.rll
> ..\80\Tools\Binn\Resources\1033\pfclnt80.rll
> ..\80\Tools\Binn\Resources\1033\pfutil80.rll
> ..\80\Tools\Binn\Resources\1033\profiler.rll
> ..\80\Tools\Binn\Resources\1033\rebuildm.rll
> ..\80\Tools\Binn\Resources\1033\semcomn.rll
> ..\80\Tools\Binn\Resources\1033\semcros.rll
> ..\80\Tools\Binn\Resources\1033\semdll.rll
> ..\80\Tools\Binn\Resources\1033\semdts.rll
> ..\80\Tools\Binn\Resources\1033\semexec.rll
> ..\80\Tools\Binn\Resources\1033\semmap.rll
> ..\80\Tools\Binn\Resources\1033\semnt.rll
> ..\80\Tools\Binn\Resources\1033\semobj.rll
> ..\80\Tools\Binn\Resources\1033\semrepl.rll
> ..\80\Tools\Binn\Resources\1033\semsfc.rll
> ..\80\Tools\Binn\Resources\1033\semsys.rll
> ..\80\Tools\Binn\Resources\1033\semwebwz.rll
> ..\80\Tools\Binn\Resources\1033\semwiz.rll
> ..\80\Tools\Binn\Resources\1033\sqladevn.rll
> ..\80\Tools\Binn\Resources\1033\sqldmo.rll
> ..\80\Tools\Binn\Resources\1033\sqlftwiz.rll
> ..\80\Tools\Binn\Resources\1033\sqlgui.rll
> ..\80\Tools\Binn\Resources\1033\sqlmangr.rll
> ..\80\Tools\Binn\Resources\1033\sqlmmc.rll
> ..\80\Tools\Binn\Resources\1033\sqlns.rll
> ..\80\Tools\Binn\Resources\1033\sqlqry.rll
> ..\80\Tools\Binn\Resources\1033\sqlsui.rll
> ..\80\Tools\Binn\Resources\1033\sqlsvc.rll
> ..\80\Tools\Binn\Resources\1033\sqlvdir.rll
> ..\80\Tools\Binn\Resources\1033\svrnetcn.rll
> ..\80\Tools\Binn\Resources\1033\wiztrace.rll
> ..\80\Tools\Books\acdata.chi
> ..\80\Tools\Books\acdata.chm
> ..\80\Tools\Books\adminsql.chi
> ..\80\Tools\Books\adminsql.chm
> ..\80\Tools\Books\adosql.chi
> ..\80\Tools\Books\adosql.chm
> ..\80\Tools\Books\architec.chi
> ..\80\Tools\Books\architec.chm
> ..\80\Tools\Books\bldgapps.chi
> ..\80\Tools\Books\bldgapps.chm
> ..\80\Tools\Books\coprompt.chi
> ..\80\Tools\Books\coprompt.chm
> ..\80\Tools\Books\createdb.chi
> ..\80\Tools\Books\createdb.chm
> ..\80\Tools\Books\createdw.chi
> ..\80\Tools\Books\createdw.chm
> ..\80\Tools\Books\dblibc.chi
> ..\80\Tools\Books\dblibc.chm
> ..\80\Tools\Books\dbmigwiz.chi
> ..\80\Tools\Books\dbmigwiz.chm
> ..\80\Tools\Books\dbmntwiz.chi
> ..\80\Tools\Books\dbmntwiz.chm
> ..\80\Tools\Books\distsql.chi
> ..\80\Tools\Books\distsql.chm
> ..\80\Tools\Books\dtsdsgnr.chi
> ..\80\Tools\Books\dtsdsgnr.chm
> ..\80\Tools\Books\dtsprog.chi
> ..\80\Tools\Books\dtsprog.chm
> ..\80\Tools\Books\dtsrunui.chi
> ..\80\Tools\Books\dtsrunui.chm
> ..\80\Tools\Books\dtssql.chi
> ..\80\Tools\Books\dtssql.chm
> ..\80\Tools\Books\dtswizrd.chi
> ..\80\Tools\Books\dtswizrd.chm
> ..\80\Tools\Books\entrmgr.chi
> ..\80\Tools\Books\entrmgr.chm
> ..\80\Tools\Books\eqbol.chi
> ..\80\Tools\Books\eqbol.chm
> ..\80\Tools\Books\esqlforc.chi
> ..\80\Tools\Books\esqlforc.chm
> ..\80\Tools\Books\fulltxt.chi
> ..\80\Tools\Books\fulltxt.chm
> ..\80\Tools\Books\glossary.chi
> ..\80\Tools\Books\glossary.chm
> ..\80\Tools\Books\hlpview.chi
> ..\80\Tools\Books\hlpview.chm
> ..\80\Tools\Books\howtosql.chi
> ..\80\Tools\Books\howtosql.chm
> ..\80\Tools\Books\iisadmin.chi
> ..\80\Tools\Books\iisadmin.chm
> ..\80\Tools\Books\indextun.chi
> ..\80\Tools\Books\indextun.chm
> ..\80\Tools\Books\instsql.chi
> ..\80\Tools\Books\instsql.chm
> ..\80\Tools\Books\mdacxml.chi
> ..\80\Tools\Books\mdacxml.chm
> ..\80\Tools\Books\netconf.chi
> ..\80\Tools\Books\netconf.chm
> ..\80\Tools\Books\odbcsql.chi
> ..\80\Tools\Books\odbcsql.chm
> ..\80\Tools\Books\odssql.chi
> ..\80\Tools\Books\odssql.chm
> ..\80\Tools\Books\olapdmad.chi
> ..\80\Tools\Books\olapdmad.chm
> ..\80\Tools\Books\olapdmpr.chi
> ..\80\Tools\Books\olapdmpr.chm
> ..\80\Tools\Books\oledbsql.chi
> ..\80\Tools\Books\oledbsql.chm
> ..\80\Tools\Books\optimsql.chi
> ..\80\Tools\Books\optimsql.chm
> ..\80\Tools\Books\profiler.chi|||Hi John,
Yes the full installs are on another drive and are ringfenced by the
virtual server. I am not really worried about them. It is the shared
files listed previously that I am concerned about.
Why should 2 live instances running on the server interfere with each
other when installing service packs or AS or whatever?
Is this related to http://tinyurl.com/y5attu
Why is the upgrade trying to access the file C:\Program Files\Sql
Server\80\Shared\msxmlsql.dll? What is it writing to that file?
Regards
Liam
John Bell wrote:
> Hi Liam
> The files listed are not a full install, on the other drives you will have
> copies of sqlserve.exe! As your Database engine is already on SP4 I am not
> sure if your original question is an issue? The problem may occur if you have
> two live instances running on the same server, failing over so you are only
> upgrading the one live on that server would (hopefully) avoid this.
> Installing AS SP 4 requires you to failover to the given node before the
> upgrade see http://tinyurl.com/ycsjxc
> John
>|||Hi Liam
I don't know the exactly what the file is used for, but it is mostly likely
SQLXML. There are some enhancements to XML in SP4. If you don't use this then
I would think it would not be a problem. According to
http://download.microsoft.com/download/1/b/d/1bdf5b78-584e-4de0-b36f-c44e06b0d2a3/ReadmeSql2k32sp4.htm#_installing_on_a_failover_cluster
you may need to failover to replace in use files.
The posters issue does not seem to be a common problem, but then running
multiple instances on a cluster is probably not that common!
John
"liam.caffrey@.gmail.com" wrote:
> Hi John,
> Yes the full installs are on another drive and are ringfenced by the
> virtual server. I am not really worried about them. It is the shared
> files listed previously that I am concerned about.
> Why should 2 live instances running on the server interfere with each
> other when installing service packs or AS or whatever?
> Is this related to http://tinyurl.com/y5attu
> Why is the upgrade trying to access the file C:\Program Files\Sql
> Server\80\Shared\msxmlsql.dll? What is it writing to that file?
> Regards
> Liam
>
> John Bell wrote:
> > Hi Liam
> >
> > The files listed are not a full install, on the other drives you will have
> > copies of sqlserve.exe! As your Database engine is already on SP4 I am not
> > sure if your original question is an issue? The problem may occur if you have
> > two live instances running on the same server, failing over so you are only
> > upgrading the one live on that server would (hopefully) avoid this.
> >
> > Installing AS SP 4 requires you to failover to the given node before the
> > upgrade see http://tinyurl.com/ycsjxc
> >
> > John
> >
>sql

Posting XMLA to AS from java without msmdpump.dll

I'm simply trying to invoke an Analysis Server CLR assembly procedure using MDX from a non windows machine in a a java environment. I also wish to require as little configuration on the SQL Server machine as possible.

Posting the request via HttpURLConnection as below works.

url = new URL("http://localhost//olap//msmdpump.dll ");
HttpURLConnection con = (HttpURLConnection) url.openConnection();

The question is I'd prefer not to have to require IIS plus the pump to be running on the AS server(msmdpump.dll). We know MS code is sending XMLA to the AS Database.

Why can we not use the same channel? It may not be http but I do not care. I'd rather have minimum stuff to do on the server.

Thanks in advance

Zub

I'd say in this stiuation you are probably better off using HTTP. On windows machine you can use naitive AS client : ADOMD.NET or AS OLEDB, and establish connection using TCP/IP , but coming from outside you will face quite a few problems. Configuring virtual direcory compared to ... for instance trying to figure out how to authenticate your non-windows user if by far easier task.

Hope that helps.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

post SP1 hotfix

Just curious, I'm reading about the SQL Server 2005 post SP1 hotfix and it looks like you need to install the packages in order:

SQL Server

Analysis Services

Integration Services

Notification Services

Reporting Services

Tools

My desktop is configured as an Analysis Services and Integration Services instance, but without the SQL Server proper components installed. What should my install order be? Does important note 3 about SMO and SQL-DMO still apply?

Thanks,

Keehan

What document do you refer to?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Sorry 'bout that:

http://support.microsoft.com/kb/918222

Cheers,

Keehan

|||

If you didnt install SQL Server relational engine, you should be fine with installing hotfix packges for installed components only.

Looks SQL-DMO issue only applies if you have SQL Server relational engine installed.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.