Intersect Woes.
Oct 18, 2006
I want to be able to intersect many tables. I am building my query from vb code in asp .net based on key fields entered in a search engine box.
my query should look like this, which will return the rows that will have the values var, var_2, var_3 in any columns. All three must be in a row for it to be a hit. I cant get this to work in ms sql. I don't know if it supports this feature.
select * from t where column1 Like '%var%' or column2 like '%var%' or column3 like '%var%'
intersect
select * from t where column1 Like '%var_2%' or column2 like '%var_2%' or column3 like '%var_2%'
intersect
select * from t where column1 Like '%var_3%' or column2 like '%var_3%' or column3 like '%var_3%'
I also googled around and found a where exists... But cant seem to figure out how to do multiple tables:
select * from t
where exists (select * from t where column1 Like '%var_3%' or column2 like '%var_3%' or column3 like '%var_3%')
i would like to add multiple conditions to the where exists table. Could anyone please tell me what I am doing wrong.
View 2 Replies
ADVERTISEMENT
Feb 2, 2004
Dose SQL 2000 support the intersect function? If so....could someone show me an example. If not...how do you work around the problem.
Thanks,
Trey
View 1 Replies
View Related
Apr 25, 2008
does any one know about sql intersect
View 2 Replies
View Related
Feb 27, 2008
I have: 4 tables and 1 table variable.
CCenters (ID, Name)
Campaigns (ID, Name)
Rel (ID, CCenterID, CampaignID) - [many to many]
and @SCampaigns (ID, CampaignID) - represents the selected campaigns by the user
performing the commands below I would get the centers associated with the campaigns selected.SELECT CCenterID
FROM Rel
INNER JOIN @Campaigns ON @SCampaigns.CampaignID = Rel.CampaignID
But what I really want are the common centers to the selected campaigns.
Thanks
View 1 Replies
View Related
Aug 22, 2001
How to use "INTERSECT" Operator with SQL Server 2000 ?
I tried this :
select ...
Intersect
select ...
but it doesn't work ! I have an error message : "Incorrect syntaxt near the keyword intersect" !
View 1 Replies
View Related
Mar 19, 1999
Am I hallucinating or does SQL Server 6.5 not support the EXCEPT and INTERSECT operators?
View 1 Replies
View Related
Dec 21, 2003
Hi everyone, I'm trying to run the following script but it keeps giving me errors (Syntax near the work INTERSECT).
SELECT [stuff], [things], [others], [everyone]
FROM [TABLE] JOIN (
(SELECT [stuff]
FROM [TABLE]
WHERE [item] = '1' )
INTERSECT
(SELECT [stuff]
FROM [TABLE]
WHERE [item2] = '1' )
) temp ON temp.[stuff] = [stuff]
NOTE: If I replace the word INTERSECT with UNION it works fine, just that I'm wanting an intersect not a union!!
Can anyone help me out with this?
Andrew
View 3 Replies
View Related
Oct 3, 2007
hi
can any one help me to solve this question?
View 5 Replies
View Related
Jul 20, 2005
Hi,I've used the minus functionality which is available in Oracle andi would like to use it in SQL server, but i don't know how to. Thefolllowing is how it works in OracleSelect symbols from symbol_tableminusselect tsymbols from tradeIt returns a list of all the symbols from symbol_table which are notpresent in trade.Similarly, the intersect will return only those which are common toboth.I was wondering if someone throw some light on this problem for me.Thanks in advance,Sumanth
View 1 Replies
View Related
Oct 7, 2015
I am trying to update all records in #newtable that exist in #mastertable. I have been using Intersect to show me the duplicate records, but now I need to update a field in #newtable This was my syntax to show the records that exist in both tables, how can I change this to an update statement? The field in #newtable I want to update is [alreadyexists] and I want to update it with a yes value
So update #newtable set [alreadyexists] = 'yes'
select uno, mucha, pablo, company from #Newtable
intersect
select uno, mucha, pablo, company from #mastertable
View 5 Replies
View Related
Jan 13, 2014
These two T-SQL statements return the same results.
If Microsoft deemed it necessary to add the EXCEPT command, then what are its advantages over an INNER JOIN
-- LIST ONLY PRODUCTS THAT ARE ON A WORK ORDER
USE AdventureWorks2008R2;
GO
SELECT ProductID
FROM Production.Product
INTERSECT
SELECT ProductID
FROM Production.WorkOrder ;
USE AdventureWorks2008R2;
GO
SELECT DISTINCT Production.WorkOrder.ProductID
FROM Production.Product
INNER JOIN Production.WorkOrder ON Production.WorkOrder.ProductID = Production.Product.ProductID
View 9 Replies
View Related
Apr 25, 2006
Hi,We are in the process of buying a new server to run mssql. Howeverbefore this as a tempory fix to using a msaccess backend i believethrough odbc i need to address the following issue:SELECT ai.entry_date as CallTime,ai.agent_login as AgentsLogin,ai.campaign as MarketingCampaign,ai.agent_input2 as ProductsSold,ai.first_name as Cust_FirstName,ai.last_name as Cust_LastName,ai.agent_input1 as Cust_PersonalNumber,ai.street_address as Cust_AddressStreet,ai.city as Cust_AddressCity,ai.state as Cust_AddressState,ai.zip as Cust_AddressZIP,rec.file_name as AgreementRecordingFileFROM agent_input ai, leads l, recordings recWHERE ai.whole_phone_number = l.whole_phone_number ANDl.call_status = 1110 ANDrec.whole_phone_number = l.whole_phone_number ANDrec.last_name = l.last_name ANDrec.agent = ai.agent_login ANDrec.campaign = l.campaign ANDlast_call_date between #04/24/2006 12:00 AM# and #04/25/2006 11:59 PM#ORDER BY ai.agent_login, ai.entry_dateI want to make the recordings entry optional so the same results comeout whether it matches a recording or not. If it does i want it topopulate the AgreementRecordingFile column above, if not just put a ''as you would with '' as AgreementRecordFile.Does anyone know how you can do this, in a access based database systemusing SQL through i believe ODBC?ThanksDavid
View 1 Replies
View Related
Sep 21, 2006
Hi,I'm coming back to Sql Server after 4 years away, using other RDBMS,and there's a few things I'm struggling to remember how to do (if Icould do them in the first place...)Main amongst those is EXCEPT syntax.In DB2, if I have two sets of data and I want to exclude the second setfrom the first, I can do:SELECT col1, col2, col3, ... colNFROM table1EXCEPTSELECT col1, col2, col3, ... colNFROM table2;But SQL Server balks at this. I've had a quick look in the T-SQL helpfor EXCEPT, but I didn't find that particularly enlightening. Anypointers as to how I should be doing this?ThanksJames
View 5 Replies
View Related
Nov 14, 2007
Hi people!!!
First I'll introduce my situation.
I have the folowing tables:
1.- Table "Codes", DataBase "COD", server 1001
2.- Table "Codes", DataBase "COD", server 1002
Both servers run SQL Server 2000 Edition.
What i need to perform is a check that compares the data stored in both tables in order to know if there is any difference between them. Of course, the structure of both tables are the same.
I use the SP sp_addlinkedserver to link the servers, but the problem is that EXCEPT and INTERSECT didn't work.
Anyone can help me?
Thanks,
Bob
P.S.: Please!!!!!!!!!
View 6 Replies
View Related
Jun 5, 2015
I have a table (let's call it MyTable) that consists of four fields:
Id, Source, FirstField, and
SecondField, where Source only takes one of two values:
Source1 and Source2.
The records in this table look as follows:
Id
Source
FirstField
Secondfield
1
Source1
Product 3 name
Product 3 description
[code]...
I need to return, using 3 different T-SQL queries:
1) Products that exist only in Source2 (in red above)
2) Products that exist only in Source1 (in green above)
3) Products that exist both in Source1 and Source2 (in black above)
For 1) so far I've been doing something along the lines of SELECT * FROM MyTable WHERE Source=Source1 AND FirstField NOT IN (SELECT DISTINCT (FirstField) FROM MyTable WHERE Source=Source2)
I have read about INTERSECT and EXCEPT, but I am a little unclear if they could be applied in this case out of the box.
View 7 Replies
View Related
Jun 4, 2015
Here's the scenario. I have a table (let's call it MyTable) that consists of four fields: Id, Source, FirstField, and SecondField, where Source only takes one of two values: Source1 and Source2.
The records in this table look as follows:
I need to return, using 3 different T-SQL queries:
1) Products that exist only in Source2 (in red above)
2) Products that exist only in Source1 (in green above)
3) Products that exist both in Source1 and Source2 (in black above)
For 1) so far I've been doing something along the lines of
SELECT * FROM MyTable WHERE Source=Source1 AND FirstField NOT IN (SELECT DISTINCT(FirstField) FROM MyTable WHERE Source=Source2)
Not being a T-SQL expert myself, I'm wondering if this is the right or more efficient way to go. I have read about INTERSECT and EXCEPT, but I am a little unclear if they could be applied in this case out of the box.
View 5 Replies
View Related
May 29, 2015
Link : [URL] .....
This provides a good example for my situation. In this example, you will see a Movie dimension with four attributes; Genre, Language, Movie, and Theme. I have a similar setup except mine is Top Level Hierarchy>Categories>Values which are all under the one hierarchy.
My Question: I have the dimension setup as a multi-value parameter in one of my reports. When I filter on a value in Genre and in Language, it provides all values from that genre and all values from that language. I really only want the values that include both.
Genre - Western: Movie1, Movie2, Movie3
Language - English: Movie2, Movie4, Movie5
If I filter on Western and English, I get Movie1-5 when all I really want is Movie2 only. Is there any way to have this do an Intersect within the same dimension or do I have to build each one out into its own dimension?
View 10 Replies
View Related
May 12, 2015
I have two tables, D and C, whose INTERSECT / EXCEPT values I'd like to insert in the following table I've created
CREATE TABLE DinCMatch (
servername varchar(50),
account_name varchar (50),
date_checked datetime DEFAULT getdate()
)
The following stmt won't work...
INSERT INTO DinCMatch
select servername, account_name from D
intersect
select servername, account_name from C
... as the number of supplied values does not match table definition.
View 2 Replies
View Related
Nov 26, 2001
I have a DTS setup that copies a couple of databases from one server to another in order to have a hot backup server. When I execute the DTS package from the DTS portion of the Enterprise Manager tree it runs fine. When I schedule it, it fails with the following error:
DTSRun OnStart: DTSStep_OMWCustomTasks.OMWTransferLogins_1
DTSRun OnError: DTSStep_OMWCustomTasks.OMWTransferLogins_1, Error = -2147467259 (80004005)
Error string: Unspecified error
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 700
I cannot find anywhere where this error is explained or even referenced. Any help would be greatly appreciated.
View 2 Replies
View Related
Mar 9, 2000
Here's the table:
Create Table{
id int
comments text}
Much of the data in the Comments field already has carriage return in it. When I use bcp out -c, it uses as a new record to figure out when the new row stats. However, the data in that column has carriage returns! Hence, when it detects the carriage return in the user data(comments) itself, it is pushing the remainder of that text to the 2nd line. Then, when I try to BCP IN, it is trying to push it into ID column!
The text file looks something like this:
ID COMMENTS
-- ---------
1 This is a very long comment with a line return now. User hits return here.
This should be part of the previous record but gets detected as a new row
2 Some Text
3 Some Text
So, in the BCP IN, it is trying to put 'This should be part of..' into the ID column and I am getting an error.
Is there any way I can get BCP to NOT recognize in user data as end of a record??
Thanks
Joyce
View 1 Replies
View Related
Jan 10, 2007
We've had RS running on an internal network for a while now and initially
installed it with no SSL certificate. We recently decided that we would like
to make some reports available through the web, and that we should secure the
data with SSL. So, we registered and set up the subdomain, bought and
installed the certificate, closed off all but port 443 on the box in
question, and opened it up to the world. We tweaked a few options in the RS
config files (after reading around):
RSReportServer.config:
- SecureConnectionLevel changed from 0 to 2 (recommended) - this changed
all but the help file links to https://.
- UrlRoot changed from HTTP to HTTPS, and also changed from internal to
external name (to match the SSL certificate)
RSWebApplication.config:
- ReportServerUrl changed from HTTP to HTTPS and changed from internal to
external name.
After this was changed, along with some IIS tweaks, we were able to get to
the report manager through the web, and force SSL only. The problem right
now is that we are intermittently getting "Underlying connection closed"
errors (described here: http://support.microsoft.com/kb/915599). ; The odd
thing is that we first get the Windows login prompt, wait about a minute then
get the error (which is encapsulated by the Report Manager page style).
After a quick browser refresh, the Report Manager appears almost instantly,
with no 2nd request for a windows login.
My question: Are there any IIS or RS config settings I can look at, or any
log file entries I should look for in order to determine the cause of this
problem? My guess at this point is the error has to do with some sort of
timeout, but to be honest, I have no clue.
Thanks in advance!
View 1 Replies
View Related
Jan 24, 2000
Taking the advise from one of the postings I removed the setting for checkpoint log
on checkpoint. I have set up a batch job that does a dbcc checktable (syslogs)
and a dump transaction with no_log every 15 minutes. We are a development
shop and do not need the transaction log, I would have liked to use the truncate
log on checkpoint. I found that the transaction log seems to grow indefinitely by
viewing DBCC sqlPerf and sp_spaceused if I do not first issue the checktable
command. Why is this needed? This is the same problem I had with the truncate log
on checkpoint option. Has anyone else encountered a similar problem? We have an
application that does single row inserts multithreaded at a rate of 2500 rows a second.
Without performing the dbcc checktable the log filled to over 80% in a 45 minute period.
Running the stored procedure with the two commands the logs stays under 40%.
View 1 Replies
View Related
Nov 10, 2004
Trying to get my jobs to send mail when job fails. Should be easy but it's giving me headache
Had a whole slew of issues. Outlook is installed with a n outlook mail profile set up that can send mail in outlook. I can create a SendMail DTS and execute it to send mail
Email works in these scenarios
1. I create a DTS package in SQL Server with just SendMail with the same Profile "ABC" and click Execute and it sends
2. I can send using Outlook with the same profile "ABC"
3. I can run DTSRun with command prompt calliing the DTS package and it sends fine
However it wont send in these 3 scenarios (where I need it!):
1. I go to Operator, and put my Profile "ABC" in the Email Name, click Test and I get this error "Error 22022: SQLServerAgent Error: The SQLSErverAgent mails ession is not running; check the mail profile and/or the SQLServerAgent service startup account in the SQLSErverAGent Properties
sQLServer Agent is running
2. If I add the DTS Package "EmailTest" to one of my jobs as a step to go to if the 1st step fails, nothing gets sent
3. In JObs -- Notificatioin, If I set the E-maill operator to my operator, nothing gets sent
I set the Mail Profile to the Mail Profile (in SQL Server AGent' properties)
However when I click Test, I get this error:
Error 0: Cannot load the DLL sqlmap70.dll, or one of the DLLs it references
I am using
SQLServer Version 8.00.194,
OS Windows 2003
Help!
View 1 Replies
View Related
Dec 16, 2006
Hi everybody.
I don't know if anyone can help me but I have two issues with SQL Server 2000 SP4 (version 8.00.2039 - Desktop Engine) running on W2K and W2K3. I'm also running SQLXML 3.0 (msxml2.dll version is 8.30.9530.0).
Is it me or is sp_xml_preparedocument a crippled fat dog that is blind?...not that I have anything against crippled fat dogs that are blind :)
In all the stored procs I have developed, I pass a text var as an input parameter and return an IStream to ADO (using an sqlxml provider) in COM+. All has been very well and fine...until the passed text parameter resembles a data object of any decent size.
The first error I was noticing was a "XML Parsing Error: not enough storage is available to complete this operation". Well, I thought I would debug logically in a step fashion and just prepare the doc first and then do a return and then do a return on the next segment of code to find out where the issue is. I was amazed to find that sp_xml_preparedocument is taking 7 seconds to load a simple 1MByte text input var and around three minutes to load a 7 MByte file.
I believe these long load times are causing issues with transaction timouts etc so I thought I would try to solve the speed issue with sp_xml_preparedocument and then see if the "XML Parsing Error" continues.
So, my first question is:
Should sp_xml_preparedocument take 7 seconds to load a 1MByte text variable and nearly three odd minutes to load a 7 MByte file? Surely there is something wrong somewhere?
I'm also running these tests on two machines - one is 2 GHz and the other is 2.4 GHz P4's.
Cheers and thanks for any info.
Erron
View 2 Replies
View Related
May 28, 2008
SELECT T1.*
FROM Cust_Table T1
INNER JOIN
(
SELECT Family_Name
FROM Cust_Table
WHERE Cust_Name IN ('Billy', 'John')
AND RowNum < 100
GROUP BY Family_Name
HAVING COUNT(*) > 1
)
T2 ON T1.Family_Name= T2.Family_Name
WHERE RowNum < 100
( This code above finds all the familys that contain either multiple billys and/or multiple Johns and displays all the duplicates ordered by the family_name. )
The problem is that what I want it to do is search through the whole table and find within each Family (Family_ID) who has both a sibling called Billy AND John (Cust_Name) wether they have multiple johns and multiple billys I don't mind as long as they have a minimum of 1 of each. I then want to just output all those examples only not anything else. An example of the table is bellow, I hope this helps. Thanks for your advice.
BEFORE
Family_Name CUST_Name
Bruce Billy
Bruce John
Bruce Mike
Bruce Oli
Smith Billy
Smith Billy
Harold John
AFTER
Family_Name CUST_Name
Bruce Billy
Bruce John
View 4 Replies
View Related
Jul 20, 2005
Trying to get my jobs to send mail when job fails. Should be easy butit's giving me headacheHad a whole slew of issues. Outlook is installed with a n outlookmail profile set up that can send mail in outlook. I can create aSendMail DTS and execute it to send mailEmail works in these scenarios1. I create a DTS package in SQL Server with just SendMail with thesame Profile "ABC" and click Execute and it sends2. I can send using Outlook with the same profile "ABC"3. I can run DTSRun with command prompt calliing the DTS package andit sends fineHowever it wont send in these 3 scenarios (where I need it!):1. I go to Operator, and put my Profile "ABC" in the Email Name,click Test and I get this error "Error 22022: SQLServerAgent Error:The SQLSErverAgent mails ession is not running; check the mail profileand/or the SQLServerAgent service startup account in theSQLSErverAGent PropertiessQLServer Agent is running2. If I add the DTS Package "EmailTest" to one of my jobs as a stepto go to if the 1st step fails, nothing gets sent3. In JObs -- Notificatioin, If I set the E-maill operator to myoperator, nothing gets sentI set the Mail Profile to the Mail Profile (in SQL Server AGent'properties)However when I click Test, I get this error:Error 0: Cannot load the DLL sqlmap70.dll, or one of the DLLs itreferencesI am usingSQLServer Version 8.00.194,OS Windows 2003Help!
View 3 Replies
View Related
Nov 28, 2007
Hello,
I have a view with approximately 5 and a half million rows in it. I need to transfer these rows to a table of the same schema.
If I run the "SELECT * INTO TABLE FROM VIEW" query in Mgmt Studio it takes 13 minutes to complete.
If I run the "INSERT INTO TABLE SELECT * FROM VIEW" query in Mgmt Studio it takes 16 minutes to complete.
If I create a stored procedure which simply executes the "INSERT INTO TABLE SELECT * FROM VIEW" query it takes over an hour to complete.
Why is there such a disparity between the different methods?
View 3 Replies
View Related
Sep 21, 2007
I'm baffled by this error but I'm guessing once someone points it out, it will a oh duh! moment. I have a proc. I want to get the results of the proc into a temp table. I've tried both SELECT INTO and INSERT INTO. Both give me the error "Invalid object name #HACK" which is the tmp table name I've used.
CREATE PROCEDURE tmp_weed
AS
SELECT * FROM Invoice WHERE InvoiceID = 10007
GO
INSERT INTO #HACK
EXEC tmp_weed
Invalid object name '#HACK'.
hope someone can point out the obvious...thnx
Matt
View 9 Replies
View Related
Jul 20, 2006
Hello,
I'm experiencing a problem using transactions within a package, and would be grateful if anyone can help out. A search on the forum has turned up a number of similar posts but I don't think any of them deal specifically with my problem (and I didn't find an existing solution), but apologies if this is considered a duplicate!
I have two Sequence Containers in a package, each of which contains a number of Data Flow Tasks responsible for copying data from one SS2k5 database to another (on the same server). There is a precedence constraint between the two Sequence Containers (within each container the Data Flow Tasks run in parallel, although I don't think this is relevant).
I need each Sequence Container to execute transactionally i.e. within each Container the Data Flows must either all succeed or all fail. However I don't want the package as a whole to execute transactionally i.e. I don't want the two Sequence Containers within a single transaction, but rather to each start a transaction of their own. So, accordingly I have set the TransactionOption property of the package to Supported, and the TransactionOption property of each of the Sequence Containers set to Required. Each Data Flow Task has TransactionOption of Supported.
All is well when I run the package by itself, but unfortunately within my ETL this package is invoked as the child of another package, and when this happens the first sequence container fails with error message:
"The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D00A "Unable to enlist in the transaction.""
Some quick Googling turned up the following MS Support article that seems to pretty much describe my situation and acknowledge it as a SSIS bug:
http://support.microsoft.com/?kbid=914375
However there is a bit of a problem: the article claims this problem is fixed in Service Pack 1 ... but I'm already running Service Pack 1 (Build 2047). Additionally, the alternative workaround given doesn't help me (unless I'm misunderstanding) since I don't want the two Sequence Containers running in the same transaction and so can't set their TransactionOption to Supported and rely on them joining an existing transaction.
I am aware of the post-SP1 SS hotfix but had some problems with my AS installation when I upgraded to this a while back, so I'm keen to stay with my fresh SP1 unless someone can assure me that the hotfix addresses this issue (and I can't see any mention of an issue such as this in the hotfix notes).
I guess an alternative workaround would be to use native SQL Server transactions instead of MSDTC by including explicit T-SQL transaction commands within my Sequence Containers (and RetainSameConnection on the Connection Manager), but I'm reluctant to modify my packages to do this unless necessary, since I believe the intrinsic transaction support should be able to cover what I'm trying to achieve?
Has anybody else experienced this problem even on SP1, or am I perhaps misunderstanding how to use transactions in SSIS (this is the first time I've used them)?
Many thanks,
Jon
View 1 Replies
View Related
Apr 11, 2007
Hello,
I've run into a problem trying to install SP2 for SQL2005 on a Server 2003 system. I tried to troubleshoot this myself but the logs are just not verbose enough. The box was just rebuilt with Server 2003, then SP2 for 2003 was immediately applied. SQL2005 was then installed. In my attempt to install SP2 for SQL2005, the following errors occured:
Summary.txt
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.
----------------------------------------------------------------------------------
Product : Analysis Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixOLAP9_Hotfix_KB921896_sqlrun_as.msp.log
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.
----------------------------------------------------------------------------------
Hotfix.log
04/11/2007 09:26:13.317 Locked file: Checking for locked files
04/11/2007 09:26:16.692 Attempting to pause the 32 bit ngen queue
04/11/2007 09:26:16.848 Installing product: SQL9
04/11/2007 09:26:16.848 Installing instance: MSSQLSERVER
04/11/2007 09:26:16.848 Installing target: MINKE
04/11/2007 09:26:16.848 Installing file: sqlrun_sql.msp
04/11/2007 09:26:16.864 Copy Engine: Creating MSP install log file at: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
04/11/2007 09:26:16.864 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
04/11/2007 09:26:16.864 Registry: Cannot read registry key value "Debug"
04/11/2007 09:26:25.411 MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.
04/11/2007 09:26:26.239 MSP returned 1603: A fatal error occurred during installation.
04/11/2007 09:26:26.255 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
04/11/2007 09:26:26.255 Registry: Cannot read registry key value "Debug"
04/11/2007 09:26:26.911 Copy Engine: Error, unable to install MSP file: d: a41f59141805a7af3438aHotFixSQLFilessqlrun_sql.msp
04/11/2007 09:26:26.911 The following exception occurred: Unable to install Windows Installer MSP file Date: 04/11/2007 09:26:26.911 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllcopyengine.cpp Line: 800
04/11/2007 09:26:27.286 Watson: Param1 = SetInstanceProperty
04/11/2007 09:26:27.286 Watson: Param2 = 0x7358
04/11/2007 09:26:27.286 Watson: Param3 = SetInstanceProperty
04/11/2007 09:26:27.286 Watson: Param4 = 0x7358
04/11/2007 09:26:27.286 Watson: Param5 = sqlcasqlcax.cpp@1223
04/11/2007 09:26:27.286 Watson: Param6 = Unknown
04/11/2007 09:26:27.286 Watson: Param7 = SQL9
04/11/2007 09:26:27.286 Watson: Param8 = Hotfix@
04/11/2007 09:26:27.286 Watson: Param9 = x86
04/11/2007 09:26:27.286 Watson: Param10 = 3042
04/11/2007 09:26:27.301 Installed product: SQL9
04/11/2007 09:26:27.301 Installing product: OLAP9
04/11/2007 09:26:27.301 Installing instance: MSSQLSERVER
04/11/2007 09:26:27.301 Installing target: MINKE
04/11/2007 09:26:27.317 Installing file: sqlrun_as.msp
04/11/2007 09:26:27.317 Copy Engine: Creating MSP install log file at: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixOLAP9_Hotfix_KB921896_sqlrun_as.msp.log
04/11/2007 09:26:27.317 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
04/11/2007 09:26:27.317 Registry: Cannot read registry key value "Debug"
04/11/2007 09:26:32.020 MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.
04/11/2007 09:26:32.552 MSP returned 1603: A fatal error occurred during installation.
04/11/2007 09:26:32.567 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
04/11/2007 09:26:32.567 Registry: Cannot read registry key value "Debug"
04/11/2007 09:26:33.348 Copy Engine: Error, unable to install MSP file: d: a41f59141805a7af3438aHotFixASFilessqlrun_as.msp
04/11/2007 09:26:33.348 The following exception occurred: Unable to install Windows Installer MSP file Date: 04/11/2007 09:26:33.348 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllcopyengine.cpp Line: 800
04/11/2007 09:26:33.755 Watson: Param1 = SetInstanceProperty
04/11/2007 09:26:33.755 Watson: Param2 = 0x7358
04/11/2007 09:26:33.755 Watson: Param3 = SetInstanceProperty
04/11/2007 09:26:33.755 Watson: Param4 = 0x7358
04/11/2007 09:26:33.755 Watson: Param5 = sqlcasqlcax.cpp@1223
04/11/2007 09:26:33.755 Watson: Param6 = Unknown
04/11/2007 09:26:33.755 Watson: Param7 = OLAP9
04/11/2007 09:26:33.755 Watson: Param8 = Hotfix@
04/11/2007 09:26:33.755 Watson: Param9 = x86
04/11/2007 09:26:33.755 Watson: Param10 = 3042
04/11/2007 09:26:33.770 Installed product: OLAP9
04/11/2007 09:26:33.770 Hotfix package completed
04/11/2007 09:26:33.770 Attempting to continue the 32 bit ngen queue
Any help would be appreciated. Thanks in advance.
Regards,
Nathan
View 3 Replies
View Related
Nov 20, 2005
I installed VS 2005 & SQL Server 2005.
View 25 Replies
View Related
Nov 3, 2006
The following issue is happening a lot these days. For all the world it looks like a bug in BIDS:
I set a breakpoint in a Script Task (not a Script Component!) and the code dutifully stops on the breakpoint over and over again, as expected. (Please don't tell me about not being able to debug Script Components!)
At some point, when I run the package and hit the Script Task, the VSA editor opens as if it's going to take me to the breakpoint, but then it displays an error dialog box containing the following message:
Microsoft Visual Studio has lost its link to .
You work will be exported to C:Documents and SettingsmgrohMy Documents when you quit the application
(Notice the space between "its link to" and the period in the first statement. It goes without saying that nothing is exported to My Documents.)
When I dismiss the dialog, execution resumes and the break point is ignored. In fact, breakpoints in all script tasks in the project are ignored.
Clearly, something is broken in the DTSX file, and is preventing VSA from finding the breakpoint. That's the only interpretation I can come up with for the "lost its link to" part of the message.
I have tried everything I can think of:
- Deleting all breakpoints and re-establishing the breakpoint
- Making a small change to the code to force VSA to re-evaluate the module
- Shutting down and re-opening the project
- Rebooting the computer (!!!!)
And NOTHING works. The module is just broken, and breakpoints it other Script Tasks don't work, either.
This really looks like a bug in SSIS, but I can't find anyone else who's complained of the same thing.
Any ideas? TIA!
- Mike
View 13 Replies
View Related
Apr 28, 2006
Hi,
I'm having trouble with SQL 2005 SP1.
The following comes from SQL9_Hotfix_KB913090.log:
04/28/2006 15:13:27.843 ================================================================================
04/28/2006 15:13:27.843 Hotfix package launched
04/28/2006 15:13:28.718 Product discovery successfully completed during the install process for MSSQLSERVER
04/28/2006 15:13:28.718 SP Level check successfully completed during the install process for MSSQLSERVER
04/28/2006 15:13:28.718 Product language check successfully completed during the install process for MSSQLSERVER
04/28/2006 15:13:28.718 Product version check successfully completed during the install process for MSSQLSERVER
04/28/2006 15:13:28.718 Command-line instance name check completed during the install process
04/28/2006 15:13:28.718 Baseline build check completed during the install process
04/28/2006 15:14:16.375 Attempting to install instance: MSSQLSERVER
04/28/2006 15:14:16.375 Attempting to install target: DEAN
04/28/2006 15:14:16.390 Attempting to check for locked files: sqlrun_sql.msp
04/28/2006 15:14:16.421 Attempting to check for locked files: \DEANd$4c016e0f5dfb4a37300a7ce503HotFixSQLFilessqlrun_sql.msp
04/28/2006 15:14:16.421 Creating MSP locked file check log at: C:WINNTHotfixSQL9LogsSQL9_Hotfix_KB913090_sqlrun_sql.msp.out
04/28/2006 15:14:27.171 MSP returned 1602: The user cancels installation.
04/28/2006 15:14:27.187 Successfully checked file: \DEANd$4c016e0f5dfb4a37300a7ce503HotFixSQLFilessqlrun_sql.msp
04/28/2006 15:14:27.187 Successfully opened registry key: SystemCurrentControlSetControlSession Manager
04/28/2006 15:14:27.187 Failed to read registry key: PendingFileRenameOperations
04/28/2006 15:14:27.187 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxmlfilt.dll
04/28/2006 15:14:27.187 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnThaWBrkr.dll
04/28/2006 15:14:27.187 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnquery.dll
04/28/2006 15:14:27.203 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnls400.dll
04/28/2006 15:14:27.203 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnlhtml.dll
04/28/2006 15:14:27.203 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsir5jp.dll
04/28/2006 15:14:27.203 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsftesql.exe
04/28/2006 15:14:27.203 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsftepxy.dll
04/28/2006 15:14:27.218 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsftefd.exe
04/28/2006 15:14:27.218 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsfte.dll
04/28/2006 15:14:27.218 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnLangWrbk.dll
04/28/2006 15:14:27.218 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnkorwbrkr.dll
04/28/2006 15:14:27.218 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinninfosoft.dll
04/28/2006 15:14:27.218 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERefFTERef.dll
04/28/2006 15:14:27.234 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnCHTBRKR.DLL
04/28/2006 15:14:27.234 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnChsBrkr.dll
04/28/2006 15:14:27.234 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COMResources1033REPLRES.rll
04/28/2006 15:14:27.234 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COM
eplrec.dll
04/28/2006 15:14:27.234 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COM
plisapi.dll
04/28/2006 15:14:27.234 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:WINNTassemblyGAC_32Microsoft.SqlServer.Replication9.0.242.0__89845dcd8080cc91Repl.dll
04/28/2006 15:14:27.234 Failed to read associated hotfix build information for the following file: C:WINNTassemblyGAC_MSILMicrosoft.SqlServer.DataStorage9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DataStorage.dll
04/28/2006 15:14:27.234 Failed to read version information for the following file: C:Program FilesCommon FilesMicrosoft SharedDatabase ReplicationResources10332005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstall
plhtfin.sql
04/28/2006 15:14:27.234 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstall
C:Program FilesMicrosoft SQL Server90COMqrdrsvc.exe
04/28/2006 15:14:27.234 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COMsnapshot.exe
04/28/2006 15:14:27.234 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COM
eplmerg.exe
04/28/2006 15:14:27.234 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90COM ablediff.exe
04/28/2006 15:14:27.250 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COMDISTRIB.exe
04/28/2006 15:14:27.250 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnDatabaseMail90.exe
04/28/2006 15:14:27.250 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources30822005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources2052sqlevn70.rll
04/28/2006 15:14:27.250 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10422005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1041sqlevn70.rll
04/28/2006 15:14:27.250 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10402005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1036sqlevn70.rll
04/28/2006 15:14:27.250 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10332005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1031sqlevn70.rll
04/28/2006 15:14:27.250 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10282005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033XPStar90.RLL
04/28/2006 15:14:27.250 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlaccess.dll
04/28/2006 15:14:27.250 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlaccess.dll
04/28/2006 15:14:27.250 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlaccess.dll
04/28/2006 15:14:27.250 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn6.6.3.5
C:Program FilesMicrosoft SQL Server90Sharedmsxmlsql.dll
04/28/2006 15:14:27.265 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2.0.3609.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxmlrw.dll
04/28/2006 15:14:27.265 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlsvc90.dll
04/28/2006 15:14:27.265 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlsvc90.dll
04/28/2006 15:14:27.265 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlsvc90.dll
04/28/2006 15:14:27.265 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLBOOT.dll
04/28/2006 15:14:27.265 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxplog70.dll
04/28/2006 15:14:27.265 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnatchp~1.dll
04/28/2006 15:14:27.265 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAgentMail90.rll
04/28/2006 15:14:27.265 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAgentMail90.rll
04/28/2006 15:14:27.265 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAgentMail90.rll
04/28/2006 15:14:27.281 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAGENT90.RLL
04/28/2006 15:14:27.281 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAGENT90.RLL
04/28/2006 15:14:27.281 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAGENT90.RLL
04/28/2006 15:14:27.281 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAgentMail90.dll
04/28/2006 15:14:27.281 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAgentMail90.dll
04/28/2006 15:14:27.281 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAgentMail90.dll
04/28/2006 15:14:27.281 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAGENT90.EXE
04/28/2006 15:14:27.281 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAGENT90.EXE
04/28/2006 15:14:27.296 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAGENT90.EXE
04/28/2006 15:14:27.296 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90SharedResources10339.0.2047.0
C:Program FilesMicrosoft SQL Server90Sharedmsmdrdir.dll
04/28/2006 15:14:27.296 Failed to read version information for the following file: C:Program FilesCommon FilesSystemole db2.0.3609.0
C:Program FilesCommon FilesSystemole dbxmlrw.dll
04/28/2006 15:14:27.296 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsmdlocal.dll
04/28/2006 15:14:27.312 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsmdlocal.dll
04/28/2006 15:14:27.312 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsmdlocal.dll
04/28/2006 15:14:27.312 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlbrowser.exe
04/28/2006 15:14:27.312 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlbrowser.exe
04/28/2006 15:14:27.312 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlbrowser.exe
04/28/2006 15:14:27.312 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll
04/28/2006 15:14:27.328 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll
04/28/2006 15:14:27.328 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll
04/28/2006 15:14:27.328 Failed to read version information for the following file: C:Program FilesMicrosoft.NETADOMD.NET90enMicrosoft.AnalysisServices.AdomdClient.xml
04/28/2006 15:14:27.328 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft.NETADOMD.NET90Microsoft.AnalysisServices.AdomdClient.dll
04/28/2006 15:14:27.328 Failed to read associated hotfix build information for the following file: C:WINNTassemblyGAC_MSILMicrosoft.AnalysisServices.AdomdClient9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.AdomdClient.dll
04/28/2006 15:14:27.328 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033
C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033sqlcm.xml
04/28/2006 15:14:27.328 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll
04/28/2006 15:14:27.328 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll
04/28/2006 15:14:27.343 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll
04/28/2006 15:14:27.343 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll
04/28/2006 15:14:27.343 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll
04/28/2006 15:14:27.343 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll
04/28/2006 15:14:27.343 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnatchparser90.dll
04/28/2006 15:14:27.343 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnatchparser90.dll
04/28/2006 15:14:27.343 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnatchparser90.dll
04/28/2006 15:14:27.343 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources10332005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstallsysdbupg.sql
04/28/2006 15:14:27.359 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSQLSVC90.DLL
04/28/2006 15:14:27.359 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSQLSVC90.DLL
04/28/2006 15:14:27.359 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSQLSVC90.DLL
04/28/2006 15:14:27.359 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinn2.0.3609.0
C:Program FilesMicrosoft SQL Server90ToolsBinnSQLdiag.exe
04/28/2006 15:14:27.359 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinn2005.90.2047.0
C:Program FilesMicrosoft SQL Server90Sharedsqlsvc~1.dll
04/28/2006 15:14:27.359 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll
04/28/2006 15:14:27.359 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll
04/28/2006 15:14:27.359 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll
04/28/2006 15:14:27.375 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll
04/28/2006 15:14:27.375 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll
04/28/2006 15:14:27.375 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll
04/28/2006 15:14:27.375 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll
04/28/2006 15:14:27.375 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll
04/28/2006 15:14:27.375 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll
04/28/2006 15:14:27.375 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll
04/28/2006 15:14:27.375 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll
04/28/2006 15:14:27.390 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll
04/28/2006 15:14:27.390 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90Shared2005.90.2047.0
C:Program FilesMicrosoft SQL Server90Sharedsqlsqm.exe
04/28/2006 15:14:27.390 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90Shared9.0.2047.0
C:Program FilesMicrosoft SQL Server90Shareddbghelp.dll
04/28/2006 15:14:27.390 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe
04/28/2006 15:14:27.390 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe
04/28/2006 15:14:27.390 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe
04/28/2006 15:14:27.390 Failed to read associated hotfix build information for the following file: C:WINNTassemblyGAC_MSILMicrosoft.SqlServer.Rmo9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.Rmo.dll
04/28/2006 15:14:27.390 Failed to read associated hotfix build information for the following file: C:WINNTassemblyGAC_MSILMicrosoft.AnalysisServices9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.DLL
04/28/2006 15:14:27.390 Failed to read associated hotfix build information for the following file: C:WINNTassemblyGAC_MSILMicrosoft.DataWarehouse.Interfaces9.0.242.0__89845dcd8080cc91Microsoft.DataWarehouse.Interfaces.DLL
04/28/2006 15:14:27.406 Failed to read associated hotfix build information for the following file: C:WINNTassemblyGAC_MSILMicrosoft.SqlServer.RegSvrEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.RegSvrEnum.dll
04/28/2006 15:14:27.406 Failed to read associated hotfix build information for the following file: C:WINNTassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll
04/28/2006 15:14:27.406 Failed to read associated hotfix build information for the following file: C:WINNTassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll
04/28/2006 15:14:27.406 Failed to read associated hotfix build information for the following file: C:WINNTassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll
04/28/2006 15:14:27.406 Failed to read associated hotfix build information for the following file: C:WINNTassemblyGAC_MSILMicrosoft.SqlServer.ServiceBrokerEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ServiceBrokerEnum.dll
04/28/2006 15:14:27.406 Failed to read associated hotfix build information for the following file: C:WINNTassemblyGAC_MSILMicrosoft.SqlServer.WmiEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.WmiEnum.dll
04/28/2006 15:14:27.406 Failed to read associated hotfix build information for the following file: C:WINNTassemblyGAC_MSILMicrosoft.SqlServer.SqlEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SqlEnum.dll
04/28/2006 15:14:27.406 Failed to read associated hotfix build information for the following file: C:WINNTassemblyGAC_MSILMicrosoft.SqlServer.SmoEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SmoEnum.dll
04/28/2006 15:14:27.421 Failed to read associated hotfix build information for the following file: C:WINNTassemblyGAC_MSILMicrosoft.SqlServer.Smo9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.Smo.dll
04/28/2006 15:14:27.421 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlSAC.exe
04/28/2006 15:14:27.421 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedMicrosoft.SqlSac.Public.dll
04/28/2006 15:14:27.484 Attempting to install file: sqlrun_sql.msp
04/28/2006 15:14:27.531 Attempting to install file: \DEANd$4c016e0f5dfb4a37300a7ce503HotFixSQLFilessqlrun_sql.msp
04/28/2006 15:14:27.531 Creating MSP install log file at: C:WINNTHotfixSQL9LogsSQL9_Hotfix_KB913090_sqlrun_sql.msp.log
04/28/2006 15:14:27.531 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
04/28/2006 15:14:27.531 Failed to read registry key: Debug
04/28/2006 15:17:17.312 MSP returned 1603: A fatal error occurred during installation.
04/28/2006 15:17:17.359 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
04/28/2006 15:17:17.359 Failed to read registry key: Debug
04/28/2006 15:17:17.359 Unable to install MSP file: \DEANd$4c016e0f5dfb4a37300a7ce503HotFixSQLFilessqlrun_sql.msp
04/28/2006 15:17:17.359 The following exception occurred: Unable to install Windows Installer MSP file Date: 04/28/2006 15:17:17.359 File: depotsqlvaultsetupmainsetupsqlsesqlsedllcopyengine.cpp Line: 856
04/28/2006 15:17:17.406
04/28/2006 15:17:17.406 Product Status Summary:
04/28/2006 15:17:17.406 Product: SQL Server Native Client
04/28/2006 15:17:17.406 SQL Server Native Client (RTM ) - Success
04/28/2006 15:17:17.421
04/28/2006 15:17:17.421 Product: Setup Support Files
04/28/2006 15:17:17.421 Setup Support Files (RTM ) - Success
04/28/2006 15:17:17.421
04/28/2006 15:17:17.421 Product: Database Services
04/28/2006 15:17:17.421 Database Services (SP1 2047 ENU) - Failure
04/28/2006 15:17:17.421 Details: Unable to install Windows Installer MSP file
04/28/2006 15:17:17.421 Analysis Services (SP1 2047 ENU) - Not Applied
04/28/2006 15:17:17.421
04/28/2006 15:17:17.421 Product: Integration Services
04/28/2006 15:17:17.437 Integration Services (SP1 2047 ENU) - Not Applied
04/28/2006 15:17:17.437
04/28/2006 15:17:17.437 Product: Client Components
04/28/2006 15:17:17.437 Client Components (SP1 2047 ENU) - Not Applied
04/28/2006 15:17:17.437
04/28/2006 15:17:17.437 Product: MSXML 6.0 Parser
04/28/2006 15:17:17.437 MSXML 6.0 Parser (RTM ) - Not Applied
04/28/2006 15:17:17.437
04/28/2006 15:17:17.437 Product: Backward Compatibility
04/28/2006 15:17:17.437 Backward Compatibility (RTM ) - Not Applied
04/28/2006 15:17:17.437
04/28/2006 15:17:17.453 Product: Microsoft SQL Server VSS Writer
04/28/2006 15:17:17.453 Microsoft SQL Server VSS Writer (RTM ) - Not Applied
04/28/2006 15:17:17.453
View 3 Replies
View Related