Transact SQL :: Show Customized Error To Clients?
Jun 16, 2015I don't want show the DBMS error to my clients. I want show a simple error instead of SQL error.
View 3 Replies
ADVERTISEMENT
Transact SQL :: Customized Search With Special Characters?
Jun 20, 2015I am creating a key-wording module where I want to search data using the comma separated words.And the search is categorized into comma ',' and minus '-'. Take a look on the example what I exactly want to do is
I have a main table name `tbl_main` in SQL
AS_ID KWD
1 Man,Businessman,Business,Office,confidence,arms crossed
2 Man,Businessman,Business,Office,laptop,corridor,waiting
3 man,business,mobile phone,mobile,phone
4 Welcome,Greeting,beautiful,bride,celebration,wedding,woman,happiness
5 beautiful,bride,wedding,woman,happiness,mobile phone,talking
6 woman,girl,Digital Tablet,working,sitting,online
7 woman,girl,Digital Tablet,working,smiling,happiness,hand on chin
If serch text is = Man,Businessman then result AS_ID is =1,2
If serch text is = Man,-Businessman then result AS_ID is =3
If serch text is = woman,girl,-Working then result AS_ID is =4,5
What is the best why to do this?
Transact SQL :: Write Query To Generate Customized Result?
May 24, 2015I have a dataset which is like:
Month, Day, Location, TotalSales
Jan 1 A 100
Jan 1 B 200
Jan 14 A 120
Feb 2 A 130
Mar 5 B 150
I want to transform the dataset using sql query into the following format:
Month, Day, LocationATotalSales, LocationBTotalSales, TotalSales
Jan 1 100 200 300
Jan 14 120 0 120
Feb 2 130 0 130
Mar 5 0 150 150
Customized Error Output?
Jun 25, 2007I am using SSIS to load a lot of Excel, csv files. Some of the files will fail for various formating/validation reason. Is it a good way to capture the error and generate a nice error report so the provider can read it easily and correct the data files?
The error log of the package is difficult to read.
Transact SQL :: How To Show Value In Only One Group
Nov 3, 2015I have a table with "Project", "Demo" and "Value". Here is a sample. Is there a way to show the "Value" in just one Demo after a I use group by?
Project Demo Value
Project1 Adult 100
Project1 Kids 100
Project1 Adult 100
Project2 Adult 200
Project2 Adult 200
Project2 Kids 200
Project2 Kids 200
That is after I ran the SQL: I will get only: (see Project1's Kids's value is null now.
Project Demo Value
Project1 Adult 100
Project1 Kids
Project2 Adult 200
Project2 Kids 200
Transact SQL :: Show Total For Each Name
Sep 23, 2015I tried my syntax below, but it said that the field were not in the group by. This is syntax and for each of the 2 names (only small subset of real data) I need a Total column to display between each different person like so:
Total, 29, 150, 2400/60
Total, 25, 143, 2400/60
Here is syntax:
Create Table #Farquard
(
empID varchar(50),
fullname varchar(500),
break1 int,
break2 int,
dailytotal int,
workday date
)
[Code] ......
Transact SQL :: Show Particular Records Within Same Group?
Aug 13, 2015I have a table with 5 columns, let say ID,PersionID, Date, Type,Qty and source data looks like this
ID PersonID Date Type Qty
1 1 01/01/2011 Accept 5
2 1 01/01/2011 Accept 5
3 2 02/01/2010 Accept 10
4 2 02/01/2010 Deny 20
5 3 02/01/2012 Accept 15
[Code] .....
Output should look like this..look for only Type=Accept until deny is reached. After Deny,if there is a Accept ignore it.
ID PersonID Date Type Qty
1 1 01/01/2011 Accept 5 (show only one Accept row=1 becoz Type is Accept and date is same,Qtyis
same)
3 2 02/01/2010 Accept 10 (show Accept row=3,ignore deny row)
5 3 02/01/2012 Accept 15 (show Accept row=5)
6 4 05/05/2012 Accept 25 (show Accept rows=6,7 and ignore Deny & Accept rows = 8,9)
7 4 07/08/2012 Accept 20
11 6 01/01/2011 Accept 5 (show Accept rows=11,12 because Qty is different)
12 6 01/01/2011 Accept 15
Create Sample Table (ID int null, PersonID Int null, Date Datetime null , Type varchar(10) null, Qty int null)
Insert into sample values (1 ,1,'01/01/2011','Accept',5),
(2,1,'01/01/2011','Accept',5),
(3,2,'02/01/2010','Accept',10),
(4,2,'02/01/2010','Deny',20),
(5,3,'02/01/2012','Accept',15),
(6,4,'05/05/2012','Accept',25),
(7,4,'07/08/2012','Accept',20),
(8,4,'07/08/2012','Deny',5),
(9,4,'09/23/2012','Accept',23),
(10,5,'09/08/2012','Deny',12),
(11,6,'01/01/2011','Accept',5),
(12,6,'01/01/2011','Accept',15)
Transact SQL :: Query To Show Totals
Aug 28, 2015This is a query that produces a table with garbage data, but (I think) will get the point across of what I need. SQL Server 2008
Create Table SanitationGarbage
(
saleid int
,projectname varchar(200)
,typeofsale varchar(200)
[code]....
Now my select query below does not group the data like I need it to, nor does it show a total row like I need it to. How does this need to be written so the data is displayed in the proper formatting?
Select
projectname
,Count(saleID) As [Total Sales]
,Count(case when typeofsale = 'Final' then saleID else null end) As [Final Sales]
,Count(case when typeofsale = 'Pending' then saleID else null end) As [Pending Sales]
FROM SanitationGarbage
GROUP BY projectname
order by projectname asc
[code]....
Transact SQL :: Hours To Show In A Column?
Jun 19, 2015i'm trying to capture data for every hour and would like to display the hours of the day in a column.
select
case when (datepart(hh,calldate) between 0 and 7AM then 1 else 0 end as [12-7AM],
case when (datepart(hh,calldate) = 8 then 1 else 0 end as [8AM]
from table1
where cast(calldate as date) = cast(calldate as date)
My desired result should display
12-7 am
8 am
9 am
10 am
Transact SQL :: How To Show Sum Of Columns To New Column In Server
Jul 8, 2015I made a select query which shows following output as shown in picture .
Now I want to add one more column in this query to show current bags and Bags in these 2 columns i want to show calculation like in first rows currentbags column (Receivedbags-DeleiveredBags) and in currentWeight column RecivedWeight+loss-gain-Deliverdweight) which is 1400 and 697.5 after that in secound row i want to add frist rows currentbags value+ second rows (Receivedbags-DeleiveredBags) and same in weight like daily stock register so output looked like below image
There is one more column common date according to which i have to make calculation like
rid commondate recdate recbags recweight loss gain delbags delwght
101215109 01/01/2015 07/01/2015 1400 697.5 0 0 0 0
101215110 02/01/2015 08/01/2015 560 279.64 0 0 0 0
Transact SQL :: Show N Number Of Column As Per No Of Days In Month
Aug 26, 2015I want to show this kind of output
UserID UserName 1 2 3 30
OR
UserID UserName 1 2 3 31
user data saved in db select distinct UserID,Name from Userss Where IsActive=1 and order by UserID and i want to just calculate no of days in month based on year and month name supplied by user. one way i can do it. first i will create a temporary table and in loop add many columns to that table and later dump user data to specific column.
Transact SQL :: Query To Show Most Recent Value Based On Date Field
Jun 18, 2015I simply need to list the most recent value for each employee here... the value at each person's maximum date
Sample Detail Data:
EmpID Date Value
1 1/1/14 27
1 2/12/15 333
2 5/5/15 255
3 5/4/15 110
3 1/1/13 67
3 3/2/14 80
[Code] ....
What is the most efficient way to display the most recent value for each employee ID via MS SQL.?
Customized Email
Sep 20, 2007I have various SSIS packages running on my SQL Server 2005, they are mostly schadule to perform data updations from different locations over remote network.
In every task there is an email object added in so that it can notify about sucessful completion of SSIS package.
Here I want my email should contain some information about how many records updated in system ... or how long it take to complete the job.
Can i include sort of information into email object? if yes ... then how to do it?
Thanks
MIZ
Logging Customized Errors
Jun 24, 2002Hi Guys,
I have a bulk process. During the processing incase of any error I need to log error to the SQL Server Error Log.
I checked the help and found the external SP(Srv_Message_Handler) for this purpose.
I am not clear on the usage of this SP. Pls Help.
Vineet
Complex Customized Order By
Jun 4, 2007Hello All,
I am trying to do a complex ordering of my query results. Hopefully I can explain what I am trying to do. To simplify the explanation I have a table with two fields in it.
Table name: SPACE
Column names: SPACE_TYPE_ID, OWNER_ID
What I would like to to is order the results in this exact way:
SPACE_TYPE_ID = 2
SPACE_TYPE_ID = 5
SPACE_TYPE_ID = 6
OWNER_ID Alphabetically (if SPACE_TYPE_ID = 3,4,9)
SPACE_TYPE_ID = 1
SPACE_TYPE_ID = 7
SPACE_TYPE_ID = 8
Basically it will be ordered by the id unless the id is 3,4 or 9. I thought I could possibly use a UNION with three select statements but I believe I can't have three order by statements with a UNION. I also was told about temp tables in the database but have no idea how to use them. Is this a possible solution.
Any help on how to achieve this customized order would be greatly appreciated.
Thanks
jlmoshier
Matrix Report And Customized Subtotals - Can It Be Done?
May 31, 2007
I need a sales report that would display weekly amounts either sold or forecasted in matrix (pivot) form.
The data used for the report is like following (INV is sold and FC is forecasted):
rtype
region
week
wgt
INV
EU
1
150
INV
US
2
200
FC
US
2
400
FC
US
3
1000
FC
EU
2
100
I want the report to show data like this:
WEEK 1
WEEK 2
WEEK 3
TOTAL
INV
INV
FC
FC
INV
FC
EU
150
100
150
100
US
200
400
1000
200
1400
So I put region as rows, week and rtype as columns, and wgt as data field. Everything works fine except that there will be no grand totals for INV/FC. What I get is:
WEEK 1
WEEK 2
WEEK 3
TOTAL
INV
INV
FC
FC
EU
150
100
250
US
200
400
1000
1600
How can I get my totals? I know I could tailor my data to get INV/FC values into different columns to show as data fields in matrix report. But in this case, every week would always display 2 columns, which is certainly not what I want.
I also know I could add another matrix report to create a simulated total columns, but I wasn't able to "join" these 2 reports properly, there is always some space between them and the report looks unprofessionally. So I am looking for a way to do that with a single matrix.
Second question: how can I paint entire columns into different colors, so that INV is always green and FC is always blue? I tried customizing background color, but it only paints cells with values inside, leaving empty cells white. Is it possible to have the INV columns green, entirely?
Thank you in advance,
Wapper
Error: Subreport Cannot Be Shown - Show The Error?
Jan 4, 2008
Ive seen a few posts with the same title but none of them asked this question. At least what I found.
I am trying to get my subreports to show up. However, all I can get them to say is Error: Subreport could not be shown.
How can I get the error that the subreport is throwing? My environment is VS 2005
Thanks.
Customized Parameters Area For Reporting Services
Oct 23, 2006Has anyone customized the parameters area to pretty it up and make it more configurable like control number of columns etc?
Or can anyone direct me to a third party component?
Thanks.
Problem In SSRS-Customized Excel Export
Feb 25, 2008Hi...
I am creating an application where I need to export the reportviewer data into formatted excel sheet.
Ex excel sheet should have formatting-
1-Column width set to 8.3
2-Wrap text turned OFF
3-Left Justify all fields
4-Landscape default for orientation.
If I apply these formatting into the .rdl files then it is going to be applicable for all other formats
like csv,xml etc but I don't want to apply these fomatting except the excel report.
I think if I can trap any event when export button is clicked when excel is selected from dropdown menu
then it is going to solve the problem a little bit.
I need this solution as soon as possible.
Regards
Chinmay Chandra Dey
(Software Engineer)
Transact SQL :: Show (0) Amount For A Month If No Data Exists In The Table For That Month?
Nov 9, 2015I have two tables Costtable (Id,ResourceId, Amount,Date) and ResourceTable (ResourceId,Name) which shows output as below.
I want to show 0 amount for rest of the name in case of September. For e.g. if rest of the Resources does not appear in cost table they should appear 0 in amount
My Desired output
My current query
SELECT
RG.Id AS Id,
RG.Name AS Name,
ISNULL(SUM(AC.Amount), 0) AS Amount,
RIGHT(CONVERT(varchar(10), AC.[Date], 105), 7) AS [YearMonth]
[Code] ....
SQL Tools :: Server Management Studio Would Not Save Customized Settings
Aug 20, 2015We have Microsoft SQL Server Management Studio Version 10.50.2500.0.I change to "Results To Text", and "Display Results in a Separate Tab". Then I restart SQL Server Management Studio; and my settings are gone.Is there a way to save my settings?
View 3 Replies View RelatedSql Server Express Setup Installs The Silent Instattion, Can This Be Customized
May 25, 2007Hi!
I have created a setup in visual studio and set the sql server as a pre-requsites.
now when the setup is run from
setup.exe
it checks whether sql server is installed... if installed then continues otherwise install sql server express edition, now this installation is silent,
I need to set the sa password during installation of sql server . i have no option to set the password during installation, can any one help
Do I Need CAL For A Customized Program Connect To SQL Server 2005 Express Edition?
Dec 27, 2005Hi all,
I am developing a program to connect to SQL 2005 Express. I don't know if I need any CAL license in order to make the connection. If it is not necessary for the Express Edition case, how about if my client upgrate to SQL 2005 in the future? Do I need CAL license for SQL 2005?
Thanks for any advice given.
Transact SQL :: To Show Multiple Column In Multiple Rows
Aug 14, 2015I have the following database structure
Stock Depth41 Depth12 Depth34
AAA 1 2 1
BBB 2 2 4
How can I show Each Depth column as seperate row
AAA 1
AAA 2
AAA 1 as follows
Transact SQL :: Table Row Data Show In Column Data
Oct 22, 2015I have a simple table data i want want to show row data in to column data.
SELECT clblcode,mlblmsg
FROM warninglabels
My expected result will be
0001 0002 0003 0004
------- ------- -------- --------
May Cause.... Important..... Take madi........... Do Not Take.......
Show Custom Error Mesage
Aug 12, 2004Hi every body
please tell me how I can show a user-friendly message in sql server instead of this kind of message:
Cannot insert explicit value for identity column in table 'Test' when IDENTITY_INSERT is set to OFF.
Show Error Message In SSIS Email
Dec 14, 2007
I have an SSIS package set up to run various SQL scripts and to notify me if any of the SQL scripts fail. This is working fine, but when I get the email it only says that the script has failed. Is there any way to actually show the SQL result with the error in it? This would save me from having to go and manually run the script again to see the error message.
Thanks
Kate
Error: 15457 In NT Event Log - 'show Advanced Options'
May 3, 2002In SQL 2000, the following message is logged to the NT event log every time the sp_configure 'show advanced options' command is executed. This did NOT occurr in SQL 7.
"Error: 15457, Severity: 0, State: 1
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install."
Does anyone know if I can turn OFF the event logging of this message. It is confusing to the end users of our product that uses SQL 2000 as a back-end. Some of our product's code issues the sp_configure command that causes this message. It shows up as an informational message, but then the first word in the text is "Error:". I think I'll be getting a lot of support calls about this if I can't figure out a way to make it stop writting this to the event log :(
Any insight or suggestions would be most appreciated.
Can't Install SQL 2005 Delveloper Edition And Show Error With MSXML
Jun 11, 2007I can't install SQL 2005 Delveloper edition and show error with MSXML component
It shows these massage:
=== Verbose logging started: 6/11/2007 17:17:36 Build type: SHIP UNICODE 3.01.4000.4003 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe ===
MSI (c) (A8:90) [17:17:36:545]: Resetting cached policy values
MSI (c) (A8:90) [17:17:36:545]: Machine policy value 'Debug' is 0
MSI (c) (A8:90) [17:17:36:545]: ******* RunEngine:
******* Product: \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi
******* Action:
******* CommandLine: **********
MSI (c) (A8:90) [17:17:36:545]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (A8:90) [17:17:36:545]: Grabbed execution mutex.
MSI (c) (A8:90) [17:17:36:555]: Cloaking enabled.
MSI (c) (A8:90) [17:17:36:555]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (A8:90) [17:17:36:555]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (30:AC) [17:17:36:575]: Grabbed execution mutex.
MSI (s) (30:40) [17:17:36:575]: Resetting cached policy values
MSI (s) (30:40) [17:17:36:575]: Machine policy value 'Debug' is 0
MSI (s) (30:40) [17:17:36:575]: ******* RunEngine:
******* Product: \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi
******* Action:
******* CommandLine: **********
MSI (s) (30:40) [17:17:36:675]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (30:40) [17:17:36:906]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (30:40) [17:17:37:176]: File will have security applied from OpCode.
MSI (s) (30:40) [17:17:39:119]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (s) (30:40) [17:17:39:269]: SOFTWARE RESTRICTION POLICY: Verifying package --> '\inwa202746-1GSQL Server x86ServersSetupmsxml6.msi' against software restriction policy
MSI (s) (30:40) [17:17:39:269]: SOFTWARE RESTRICTION POLICY: \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi has a digital signature
MSI (s) (30:40) [17:17:41:702]: SOFTWARE RESTRICTION POLICY: \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi is permitted to run at the 'unrestricted' authorization level.
MSI (s) (30:40) [17:17:41:702]: End dialog not enabled
MSI (s) (30:40) [17:17:41:702]: Original package ==> \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi
MSI (s) (30:40) [17:17:41:702]: Package we're running from ==> C:WINDOWSInstaller3afbb9.msi
MSI (s) (30:40) [17:17:41:722]: APPCOMPAT: looking for appcompat database entry with ProductCode '{AEB9948B-4FF2-47C9-990E-47014492A0FE}'.
MSI (s) (30:40) [17:17:41:722]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (30:40) [17:17:41:722]: MSCOREE already loaded, using loaded copy
MSI (s) (30:40) [17:17:41:732]: Machine policy value 'TransformsSecure' is 0
MSI (s) (30:40) [17:17:41:732]: User policy value 'TransformsAtSource' is 0
MSI (s) (30:40) [17:17:41:732]: Note: 1: 2262 2: MsiFileHash 3: -2147287038
MSI (s) (30:40) [17:17:41:732]: Machine policy value 'DisablePatch' is 0
MSI (s) (30:40) [17:17:41:732]: Machine policy value 'AllowLockdownPatch' is 0
MSI (s) (30:40) [17:17:41:732]: Machine policy value 'DisableLUAPatching' is 0
MSI (s) (30:40) [17:17:41:732]: Machine policy value 'DisableFlyWeightPatching' is 0
MSI (s) (30:40) [17:17:41:732]: APPCOMPAT: looking for appcompat database entry with ProductCode '{AEB9948B-4FF2-47C9-990E-47014492A0FE}'.
MSI (s) (30:40) [17:17:41:732]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (30:40) [17:17:41:732]: Transforms are not secure.
MSI (s) (30:40) [17:17:41:732]: Command Line: STPSETUPTHREADID=3708 STPSETUPPROCESSID=424 EXTERNALCONTROL=1 ADDLOCAL=ALL SKIPPENDINGREBOOTCHECK=1 APPGUID={982DB00A-9C4E-436B-8707-18E113BAA44C} REBOOT=ReallySuppress CURRENTDIRECTORY=C:Program FilesMicrosoft SQL Server90Setup Bootstrap CLIENTUILEVEL=3 CLIENTPROCESSID=424
MSI (s) (30:40) [17:17:41:732]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{A60D52F8-FAAB-4544-AF65-EAC1A22E5435}'.
MSI (s) (30:40) [17:17:41:732]: Product Code passed to Engine.Initialize: ''
MSI (s) (30:40) [17:17:41:732]: Product Code from property table before transforms: '{AEB9948B-4FF2-47C9-990E-47014492A0FE}'
MSI (s) (30:40) [17:17:41:732]: Product Code from property table after transforms: '{AEB9948B-4FF2-47C9-990E-47014492A0FE}'
MSI (s) (30:40) [17:17:41:732]: Product not registered: beginning first-time install
MSI (s) (30:40) [17:17:41:732]: PROPERTY CHANGE: Adding ProductState property. Its value is '-1'.
MSI (s) (30:40) [17:17:41:732]: Entering CMsiConfigurationManager:etLastUsedSource.
MSI (s) (30:40) [17:17:41:763]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (30:40) [17:17:41:763]: Adding new sources is allowed.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding PackagecodeChanging property. Its value is '1'.
MSI (s) (30:40) [17:17:41:763]: Package name extracted from package path: 'msxml6.msi'
MSI (s) (30:40) [17:17:41:763]: Package to be registered: 'msxml6.msi'
MSI (s) (30:40) [17:17:41:763]: Note: 1: 2262 2: AdminProperties 3: -2147287038
MSI (s) (30:40) [17:17:41:763]: Machine policy value 'DisableMsi' is 0
MSI (s) (30:40) [17:17:41:763]: Machine policy value 'AlwaysInstallElevated' is 0
MSI (s) (30:40) [17:17:41:763]: User policy value 'AlwaysInstallElevated' is 0
MSI (s) (30:40) [17:17:41:763]: Product installation will be elevated because user is admin and product is being installed per-machine.
MSI (s) (30:40) [17:17:41:763]: Running product '{AEB9948B-4FF2-47C9-990E-47014492A0FE}' with elevated privileges: Product is assigned.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding STPSETUPTHREADID property. Its value is '3708'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding STPSETUPPROCESSID property. Its value is '424'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding EXTERNALCONTROL property. Its value is '1'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'ALL'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding SKIPPENDINGREBOOTCHECK property. Its value is '1'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding APPGUID property. Its value is '{982DB00A-9C4E-436B-8707-18E113BAA44C}'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding REBOOT property. Its value is 'ReallySuppress'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding CURRENTDIRECTORY property. Its value is 'C:Program FilesMicrosoft SQL Server90Setup Bootstrap'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding CLIENTUILEVEL property. Its value is '3'.
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding CLIENTPROCESSID property. Its value is '424'.
MSI (s) (30:40) [17:17:41:763]: TRANSFORMS property is now:
MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding VersionDatabase property. Its value is '300'.
MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminApplication Data
MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminFavorites
MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminNetHood
MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminMy Documents
MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminPrintHood
MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminRecent
MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminSendTo
MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminTemplates
MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersApplication Data
MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminLocal SettingsApplication Data
MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminMy DocumentsMy Pictures
MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsAdministrative Tools
MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsStartup
MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuPrograms
MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersStart Menu
MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersDesktop
MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminStart MenuProgramsAdministrative Tools
MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminStart MenuProgramsStartup
MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminStart MenuPrograms
MSI (s) (30:40) [17:17:41:803]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminStart Menu
MSI (s) (30:40) [17:17:41:803]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminDesktop
MSI (s) (30:40) [17:17:41:803]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersTemplates
MSI (s) (30:40) [17:17:41:803]: SHELL32:HGetFolderPath returned: C:WINDOWSFonts
MSI (s) (30:40) [17:17:41:803]: Note: 1: 2898 2: MS Sans Serif 3: MS Sans Serif 4: 0 5: 16
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding Privileged property. Its value is '1'.
MSI (s) (30:40) [17:17:41:803]: Note: 1: 1402 2: HKEY_CURRENT_USERSoftwareMicrosoftMS Setup (ACME)User Info 3: 2
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding USERNAME property. Its value is 'Exact'.
MSI (s) (30:40) [17:17:41:803]: Note: 1: 1402 2: HKEY_CURRENT_USERSoftwareMicrosoftMS Setup (ACME)User Info 3: 2
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding COMPANYNAME property. Its value is 'Exact Software'.
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding DATABASE property. Its value is 'C:WINDOWSInstaller3afbb9.msi'.
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding OriginalDatabase property. Its value is '\inwa202746-1GSQL Server x86ServersSetupmsxml6.msi'.
MSI (s) (30:40) [17:17:41:803]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (30:40) [17:17:41:803]: Machine policy value 'DisableRollback' is 0
MSI (s) (30:40) [17:17:41:803]: User policy value 'DisableRollback' is 0
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding UILevel property. Its value is '2'.
=== Logging started: 6/11/2007 17:17:41 ===
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding Preselected property. Its value is '1'.
MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding ACTION property. Its value is 'INSTALL'.
MSI (s) (30:40) [17:17:41:803]: Doing action: INSTALL
MSI (s) (30:40) [17:17:41:803]: Running ExecuteSequence
MSI (s) (30:40) [17:17:41:803]: Skipping action: SkipInstallCA (condition is false)
MSI (s) (30:40) [17:17:41:803]: Doing action: LaunchConditions
Action start 17:17:41: INSTALL.
Action start 17:17:41: LaunchConditions.
MSI (s) (30:40) [17:17:41:803]: Doing action: FindRelatedProducts
Action ended 17:17:41: LaunchConditions. Return value 1.
Action start 17:17:41: FindRelatedProducts.
MSI (s) (30:40) [17:17:41:813]: PROPERTY CHANGE: Adding NEWERFOUND.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1 property. Its value is '{A43BF6A5-D5F0-4AAA-BF41-65995063EC44}'.
MSI (s) (30:40) [17:17:41:813]: Skipping action: CA_SetRefCountUpgradeFlag (condition is false)
MSI (s) (30:40) [17:17:41:813]: Doing action: CA_SetRefCountNewerFoundFlag
Action ended 17:17:41: FindRelatedProducts. Return value 1.
MSI (s) (30:40) [17:17:41:813]: PROPERTY CHANGE: Adding NEWERFOUND999893F976BBB4A4DAD8F62CFA4D7C55 property. Its value is '1'.
Action start 17:17:41: CA_SetRefCountNewerFoundFlag.
MSI (s) (30:40) [17:17:41:813]: Doing action: IsPendingRebootKey
Action ended 17:17:41: CA_SetRefCountNewerFoundFlag. Return value 1.
MSI (s) (30:F8) [17:17:41:813]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI68.tmp, Entrypoint: IsPendingReboot
MSI (s) (30:1C) [17:17:41:813]: Generating random cookie.
MSI (s) (30:1C) [17:17:41:823]: Created Custom Action Server with PID 1832 (0x728).
MSI (s) (304) [17:17:41:873]: Running as a service.
MSI (s) (304) [17:17:41:873]: Hello, I'm your 32bit Impersonated custom action server.
Action start 17:17:41: IsPendingRebootKey.
No PendingFileRenameOperations
MSI (s) (30:40) [17:17:41:973]: Skipping action: CA_ErrorDifferentLang (condition is false)
MSI (s) (30:40) [17:17:41:973]: Skipping action: SetWOW (condition is false)
MSI (s) (30:40) [17:17:41:973]: Skipping action: SetWOWAppendCustomPath (condition is false)
MSI (s) (30:40) [17:17:41:973]: Skipping action: SetWOWINSTALLSQLSHAREDDIR_CUSTOMPATH (condition is false)
MSI (s) (30:40) [17:17:41:973]: Skipping action: SetWOWINSTALLSQLSHAREDDIR_CUSTOMPATH_ADD (condition is false)
MSI (s) (30:40) [17:17:41:973]: Doing action: Sqlmsirc_ValidateAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D
Action ended 17:17:41: IsPendingRebootKey. Return value 1.
MSI (s) (30:50) [17:17:41:983]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI69.tmp, Entrypoint: Sqlmsirc_ValidateAppGuid
Action start 17:17:41: Sqlmsirc_ValidateAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D.
<Func Name='Sqlmsirc_ValidateAppGuid'>
<EndFunc Name='Sqlmsirc_ValidateAppGuid' Return='0' GetLastError='0'>
MSI (s) (30:40) [17:17:42:003]: Doing action: Sqlmsirc_RefCountAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D
Action ended 17:17:42: Sqlmsirc_ValidateAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D. Return value 1.
MSI (s) (30:EC) [17:17:42:013]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI6A.tmp, Entrypoint: Sqlmsirc_RefCountAppGuid
Action start 17:17:42: Sqlmsirc_RefCountAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D.
<Func Name='Sqlmsirc_RefCountAppGuid'>
<EndFunc Name='Sqlmsirc_RefCountAppGuid' Return='2' GetLastError='0'>
Action ended 17:17:42: Sqlmsirc_RefCountAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D. Return value 3.
Action ended 17:17:42: INSTALL. Return value 3.
Property(S): ProductCode = {AEB9948B-4FF2-47C9-990E-47014492A0FE}
Property(S): Manufacturer = Microsoft Corporation
Property(S): ProductVersion = 6.00.3883.8
Property(S): ProductLanguage = 1033
Property(S): UpgradeCode = {1B117BA7-5BC1-419E-820E-7D4F3F412C7B}
Property(S): NEWERFOUND999893F976BBB4A4DAD8F62CFA4D7C55 = 1
Property(S): ARPPRODUCTICON = ARPIco
Property(S): PIDTemplate = 53934<````=````=````=````=`````>@@@@@
Property(S): PROMPTROLLBACKCOST = P
Property(S): DiskPrompt = [1]
Property(S): INSTALLLEVEL = 100
Property(S): ALLUSERS = 1
Property(S): InstallMode = Typical
Property(S): ErrorIcon = ErrorIco
Property(S): SuccessIcon = SuccessIco
Property(S): WarningIcon = WarningIco
Property(S): LicenseIcon = LicenseIco
Property(S): SetupIcon = SetupIco
Property(S): CompleteIcon = CompleteIco
Property(S): CustomIcon = CustomIco
Property(S): RepairIcon = RepairIco
Property(S): RemoveIcon = RemoveIco
Property(S): ModifyIcon = ModifyIco
Property(S): NewIcon = NewIco
Property(S): UpIcon = UpIco
Property(S): DialogBanner = BannerBmp
Property(S): WelcomeBmp = WelcomeBmp
Property(S): ApplicationUsers = AllUsers
Property(S): Details = 0
Property(S): AgreeToLicense = No
Property(S): _IsMaintenance = Reinstall
Property(S): _IsMaintenance2 = Modify
Property(S): ReinstallModeText = omus
Property(S): Display_IsBitmapDlg = 1
Property(S): Interrupted = 0
Property(S): ProductID = none
Property(S): ISENABLEDWUSFINISHDIALOG = 1
Property(S): SQLServerText1 = 0
Property(S): SQLServerVersionText1 = 0
Property(S): SQLServerVersionText2 = 0
Property(S): SQLServerVersionText3 = 0
Property(S): CA_ERRORCOUNT = 0
Property(S): CA_WARNINGCOUNT = 0
Property(S): CA_SUCCESSCOUNT = 0
Property(S): MINIMUMOS = true
Property(S): UI_SHOWCOPYRIGHT = yes
Property(S): ShowUserRegistrationDlg = 1
Property(S): ErrorDialog = ErrorDlg
Property(S): DefaultUIFont = Tahoma8
Property(S): NEWERFOUND.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1 = {A43BF6A5-D5F0-4AAA-BF41-65995063EC44}
Property(S): VersionNT = 501
Property(S): ARPHELPLINK = http://go.microsoft.com/fwlink/?LinkId=52156
Property(S): SecureCustomProperties = NEWERFOUND.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1;OLDERFOUND.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1;OLDERFOUND2.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1
Property(S): DesktopFolder = C:Documents and SettingsAll UsersDesktop
Property(S): ButtonTextStyle = {ButtonTextStyle}
Property(S): DlgTextStyle = {DlgTextStyle}
Property(S): DlgTextStyleB = {DlgTextStyleB}
Property(S): DlgTitleStyle = {DlgTitleStyle}
Property(S): DlgTitleStyleB = {DlgTitleStyleB}
Property(S): FixedStyle = {FixedStyle}
Property(S): COMPANYNAME = Exact Software
Property(S): USERNAME = Exact
Property(S): DialogTitleSetup = Setup
Property(S): DialogTitlePatch = Patch
Property(S): DialogTitleUpgrade = Upgrade
Property(S): Text_ArrowLeft = <
Property(S): Text_ArrowRight = >
Property(S): ButtonText_Next = Next
Property(S): ButtonText_Next_Hot = &Next
Property(S): ButtonText_Cancel = Cancel
Property(S): ButtonText_Cancel_Hot = &Cancel
Property(S): ButtonText_Back = Back
Property(S): ButtonText_Back_Hot = &Back
Property(S): ButtonText_Finish = Finish
Property(S): ButtonText_Finish_Hot = &Finish
Property(S): ButtonText_Update = Update >
Property(S): ButtonText_Update_Hot = &Update >
Property(S): ButtonText_Ok = OK
Property(S): ButtonText_Ok_Hot = &OK
Property(S): ButtonText_Yes = Yes
Property(S): ButtonText_Yes_Hot = &Yes
Property(S): ButtonText_No = No
Property(S): ButtonText_No_Hot = &No
Property(S): ButtonText_Abort = Abort
Property(S): ButtonText_Abort_Hot = &Abort
Property(S): ButtonText_Ignore = Ignore
Property(S): ButtonText_Ignore_Hot = &Ignore
Property(S): ButtonText_Retry = Retry
Property(S): ButtonText_Retry_Hot = &Retry
Property(S): ButtonText_Change = Change...
Property(S): ButtonText_Change_Hot = &Change...
Property(S): ButtonText_Help = Help
Property(S): ButtonText_Help_Hot = &Help
Property(S): ButtonText_Install = Install
Property(S): ButtonText_Install_Hot = &Install
Property(S): ButtonText_Exit = Exit
Property(S): ButtonText_Exit_Hot = &Exit
Property(S): ButtonText_Remove = Remove
Property(S): ButtonText_Remove_Hot = &Remove
Property(S): ButtonText_Space = Space
Property(S): ButtonText_Space_Hot = &Space
Property(S): ButtonText_Browse = Browse...
Property(S): ButtonText_Browse_Hot = Bro&wse...
Property(S): ButtonText_DiskCost = Disk Cost...
Property(S): ButtonText_DiskCost_Hot = &Disk Cost...
Property(S): LabelText_Status = Status
Property(S): LabelText_SerialNumber = &Serial Number:
Property(S): LabelText_UserName = &User Name
Property(S): LabelText_PersonName = Name
Property(S): LabelText_PersonOrganization = Company
Property(S): LabelText_InstallTo = Install to
Property(S): LabelText_Modify = &Modify
Property(S): LabelText_Repair = Re&pair
Property(S): LabelText_Remove = &Remove
Property(S): LabelText_Complete = &Complete
Property(S): LabelText_Custom = Cu&stom
Property(S): LabelText_NetworkLocation = &Network location:
Property(S): LabelText_LookIn = &Look in
Property(S): LabelText_FolderName = &Folder name
Property(S): LabelText_FeatureDescription = Feature description
Property(S): LabelText_CopyFilesFrom = Copy Files from
Property(S): LabelText_InstallFor = Install this application for
Property(S): HeadText_AdminWelcome = Welcome to the Install Wizard for
Property(S): HeadText_InstallWelcome = Welcome to the Install Wizard for
Property(S): HeadText_WelcomePatch = Welcome to the Patch for
Property(S): HeadText_SetupWelcome = Welcome to the
Property(S): HeadText_SetupWelcome2 = Setup
Property(S): HeadText_ResumeInstall = Resuming the Install Wizard for
Property(S): HeadText_SetupInterrupted = Setup Interrupted
Property(S): HeadText_LicenseAgreement = License Agreement
Property(S): HeadText_FeatureSelection = Feature Selection
Property(S): HeadText_NetworkLocation = Network Location
Property(S): HeadText_ProgramMaintenance = Program Maintenance
Property(S): HeadText_DiskSpaceRequirements = Disk Space Requirements
Property(S): HeadText_FilesInUse = Files in Use
Property(S): HeadText_DatabaseFolder = Database Folder
Property(S): HeadText_RegistrationInformation = Registration Information
Property(S): HeadText_CompletingSetup = Completing the
Property(S): HeadText_CompletingSetup2 = Setup
Property(S): HeadText_InstallingProduct = Installing
Property(S): HeadText_UninstallProduct = Uninstalling
Property(S): HeadText_ChangeDestinationFolder = Change Current Destination Folder
Property(S): HeadText_ReadyInstall = Ready to Install the Program
Property(S): HeadText_ReadyRepair = Ready to Repair the Program
Property(S): HeadText_ReadyModify = Ready to Modify the Program
Property(S): HeadText_RemoveProgram = Remove the Program
Property(S): HeadText_OutOfDiskSpace = Out of Disk Space
Property(S): DescText_FilesInUse = Some files that need to be updated are currently in use.
Property(S): DescText_RegistrationInformation = The following information will personalize your installation.
Property(S): DescText_ServerImage = Setup will create a server image of
Property(S): DescText_ServerImage2 = at a specified network location. To continue, click Next.
Property(S): DescText_InstallModifyRemove = Setup helps you install, modify or remove
Property(S): DescText_InstallModifyRemove2 = . To continue, click Next.
Property(S): DescText_PatchInstall = The Install Wizard will install the Patch for
Property(S): DescText_PatchInstall2 = on your computer. To continue, click Update.
Property(S): DescText_WizardComplete = The Install Wizard will complete the installation of
Property(S): DescText_WizardComplete2 = on your computer. To continue, click Next.
Property(S): DescText_CompleteSuspended = The Install Wizard will complete the suspended installation of
Property(S): DescText_CompleteSuspended2 = on your computer. To continue, click Next.
Property(S): DescText_SuccessfulInstallation = Setup has installed
Property(S): DescText_SuccessfulInstallation2 = successfully. Click Finish to exit.
Property(S): DescText_SuccessfulRemove = Setup has removed
Property(S): DescText_SuccessfulRemove2 = successfully. Click Finish to exit.
Property(S): DescText_SuccessfulRepair = Setup has repaired
Property(S): DescText_SuccessfulRepair2 = successfully. Click Finish to exit.
Property(S): DescText_SuccessfulModify = Setup has modified
Property(S): DescText_SuccessfulModify2 = successfully. Click Finish to exit.
Property(S): DescText_SetupInterrupted = Setup was interrupted before
Property(S): DescText_SetupInterrupted2 = could be completely installed.
Property(S): DescText_PreparingSetup = Setup is preparing the Install Wizard which will guide you through the program setup process. Please wait.
Property(S): DescText_FeatureSelection = Select the program features you want installed.
Property(S): DescText_ProgramFeaturesInstall = The program features you selected are being installed.
Property(S): DescText_ProgramFeaturesUninstall = The program features you selected are being uninstalled.
Property(S): DescText_ReadLicense = Please read the following license agreement carefully.
Property(S): DescText_SpecifyNetworkLocation = Specify a network location for the server image of the product.
Property(S): DescText_BrowseDestination = Browse to the destination folder.
Property(S): DescText_ModifyRepairRemove = Repair or remove the program.
Property(S): DescText_ReadyInstallation = Setup is ready to begin installation.
Property(S): DescText_ChosenRemove = You have chosen to remove the program from your system.
Property(S): DescText_DiskSpaceRequirements = The disk space required for the installation of the selected features.
Property(S): DescText_DiskExceedsAvailable = Disk space required for the installation exceeds available disk space.
Property(S): Text_ReRunSetup = Your system has not been modified. To complete installation at another time, please run setup again.
Property(S): Text_FinishExit = Click Finish to exit Setup.
Property(S): Text_RestoreState = You can either keep any existing installed elements on your system to continue this installation at a later time or you can restore your system to its original state prior to the installation.
Property(S): Text_RestoreClick = Click Restore or Continue Later to exit Setup.
Property(S): Text_InstallWait = Please wait while the Install Wizard installs
Property(S): Text_InstallWait2 = . This may take several minutes.
Property(S): Text_UninstallWaitText = Please wait while the Install Wizard uninstalls
Property(S): Text_UninstallWaitText2 = . This may take several minutes.
Property(S): Text_UninstallWait = Please wait while the Install Wizard uninstalls
Property(S): Text_UninstallWait2 = . This may take several minutes.
Property(S): Text_ProgressDone = Progress done
Property(S): Text_Copyright = WARNING: This program is protected by copyright law and international treaties.
Property(S): Text_BeginInstallation = Click Install to begin the installation.
Property(S): Text_ReviewChange = If you want to review or change any of your installation settings, click Back. Click Cancel to exit Setup.
Property(S): Text_AlterFeatureInstall = Click an icon in the following list to change how a feature is installed.
Property(S): Text_ConfirmExit = The installation is not yet complete. Are you sure you want to exit?
Property(S): Text_FeatureSelectionDescription = This feature requires 4 MB on your hard drive.
Property(S): Text_EnterNetworkLocation = Enter the network location or click Change to browse to a location. Click Install to create a server image of
Property(S): Text_EnterNetworkLocation2 = at the specified network location or click Cancel to exit Setup.
Property(S): Text_SelectDifferentDrive = The highlighted volumes do not have enough disk space available for the currently selected features. You can remove files from the highlighted volumes, choose to install less features onto local drives, or select different destination drives.
Property(S): Text_RepairInstallationErrors = Repair installation errors in the program. This option fixes missing or corrupt files, shortcuts, and registry entries.
Property(S): Text_RemoveFromComputer = Remove
Property(S): Text_RemoveFromComputer2 = from your computer.
Property(S): Text_UsingFilesRetry = The following applications are using files that need to be updated by this setup. Close these applications and click Retry to continue.
Property(S): Text_ClickRemove = Click Remove to remove
Property(S): Text_ClickRemove2 = from your computer. After removal, this program will no longer be available for use.
Property(S): Text_ReviewChangeBack = If you want to review or change any settings, click Back.
Property(S): Text_AllUsers = &Anyone who uses this computer (all users)
Property(S): Text_OnlyMe = Only for &me ([USERNAME])
Property(S): Text_NotAcceptTerms = I &do not accept the terms in the license agreement
Property(S): Text_AcceptTerms = I &accept the terms in the license agreement
Property(S): Text_RegInfoNameAndOrg = Enter your name and the name of your organization in the fields below.
Property(S): Text_RegInfoOrg = Enter the name of your organization in the field below.
Property(S): Upgrade_Confirmation = A lower version of this product has been detected on your system. Would you like to upgrade your existing installation?
Property(S): AdminMessage = Setup requires user to be in the administrator group in order to continue the installation process. Setup is aborting as the current user is not in the administrator group.
Property(S): SupportedOSMessage = Installation of this product failed because it is not supported on this operating system. For information on supported configurations, see the product documentation.
Property(S): ShortCutText = MSXML 6.0
Property(S): DialogTitle = MSXML 6.0 Parser Setup
Property(S): ProductName = MSXML 6.0 Parser
Property(S): ShortName = MSXML 6.0 Parser
Property(S): WrongPackage = This MSXML6.0 package is not supported on the current processor type.
Property(S): DialogPatchTitle = MSXML 6.0 Parser Patch
Property(S): SystemFolder = C:WINDOWSsystem32
Property(S): WdSfpCaMainModId.41646F16_4E6C_4E96_BF1B_772105414B9D = 86F857F6_A743_463D_B2FE_98CB5F727E09
Property(S): AppGuidRegKey = Wdsfpca_Uninstall_RegKey.86F857F6_A743_463D_B2FE_98CB5F727E09
Property(S): PackageCode = {A60D52F8-FAAB-4544-AF65-EAC1A22E5435}
Property(S): ProductState = -1
Property(S): PackagecodeChanging = 1
Property(S): STPSETUPTHREADID = 3708
Property(S): STPSETUPPROCESSID = 424
Property(S): EXTERNALCONTROL = 1
Property(S): ADDLOCAL = ALL
Property(S): SKIPPENDINGREBOOTCHECK = 1
Property(S): APPGUID = {982DB00A-9C4E-436B-8707-18E113BAA44C}
Property(S): REBOOT = ReallySuppress
Property(S): CURRENTDIRECTORY = C:Program FilesMicrosoft SQL Server90Setup Bootstrap
Property(S): CLIENTUILEVEL = 3
Property(S): CLIENTPROCESSID = 424
Property(S): VersionDatabase = 300
Property(S): VersionMsi = 3.01
Property(S): WindowsBuild = 2600
Property(S): ServicePackLevel = 2
Property(S): ServicePackLevelMinor = 0
Property(S): MsiNTProductType = 1
Property(S): WindowsFolder = C:WINDOWS
Property(S): WindowsVolume = C:
Property(S): System16Folder = C:WINDOWSsystem
Property(S): RemoteAdminTS = 1
Property(S): TempFolder = C:DOCUME~1AdminLOCALS~1Temp
Property(S): ProgramFilesFolder = C:Program Files
Property(S): CommonFilesFolder = C:Program FilesCommon Files
Property(S): AppDataFolder = C:Documents and SettingsAdminApplication Data
Property(S): FavoritesFolder = C:Documents and SettingsAdminFavorites
Property(S): NetHoodFolder = C:Documents and SettingsAdminNetHood
Property(S): PersonalFolder = C:Documents and SettingsAdminMy Documents
Property(S): PrintHoodFolder = C:Documents and SettingsAdminPrintHood
Property(S): RecentFolder = C:Documents and SettingsAdminRecent
Property(S): SendToFolder = C:Documents and SettingsAdminSendTo
Property(S): TemplateFolder = C:Documents and SettingsAll UsersTemplates
Property(S): CommonAppDataFolder = C:Documents and SettingsAll UsersApplication Data
Property(S): LocalAppDataFolder = C:Documents and SettingsAdminLocal SettingsApplication Data
Property(S): MyPicturesFolder = C:Documents and SettingsAdminMy DocumentsMy Pictures
Property(S): AdminToolsFolder = C:Documents and SettingsAll UsersStart MenuProgramsAdministrative Tools
Property(S): StartupFolder = C:Documents and SettingsAll UsersStart MenuProgramsStartup
Property(S): ProgramMenuFolder = C:Documents and SettingsAll UsersStart MenuPrograms
Property(S): StartMenuFolder = C:Documents and SettingsAll UsersStart Menu
Property(S): FontsFolder = C:WINDOWSFonts
Property(S): GPTSupport = 1
Property(S): OLEAdvtSupport = 1
Property(S): ShellAdvtSupport = 1
Property(S): Intel = 6
Property(S): PhysicalMemory = 1023
Property(S): VirtualMemory = 2183
Property(S): AdminUser = 1
Property(S): LogonUser = Administrator
Property(S): UserSID = S-1-5-21-842925246-1580818891-1957994488-500
Property(S): UserLanguageID = 1033
Property(S): ComputerName = CHUN107907-1
Property(S): SystemLanguageID = 1054
Property(S): ScreenX = 1024
Property(S): ScreenY = 768
Property(S): CaptionHeight = 25
Property(S): BorderTop = 1
Property(S): BorderSide = 1
Property(S): TextHeight = 16
Property(S): ColorBits = 32
Property(S): TTCSupport = 1
Property(S): Time = 17:17:42
Property(S): Date = 6/11/2007
Property(S): MsiNetAssemblySupport = 2.0.50727.42
Property(S): MsiWin32AssemblySupport = 5.1.2600.3019
Property(S): RedirectedDllSupport = 2
Property(S): Privileged = 1
Property(S): DATABASE = C:WINDOWSInstaller3afbb9.msi
Property(S): OriginalDatabase = \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi
Property(S): UILevel = 2
Property(S): Preselected = 1
Property(S): ACTION = INSTALL
MSI (s) (30:40) [17:17:42:093]: Note: 1: 1708
MSI (s) (30:40) [17:17:42:093]: Product: MSXML 6.0 Parser -- Installation failed.
MSI (s) (30:40) [17:17:42:093]: Cleaning up uninstalled install packages, if any exist
MSI (s) (30:40) [17:17:42:093]: MainEngineThread is returning 1603
MSI (s) (30:AC) [17:17:42:193]: Destroying RemoteAPI object.
MSI (s) (30:1C) [17:17:42:193]: Custom Action Manager thread ending.
=== Logging stopped: 6/11/2007 17:17:42 ===
MSI (c) (A8:90) [17:17:42:193]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (A8:90) [17:17:42:193]: MainEngineThread is returning 1603
=== Verbose logging stopped: 6/11/2007 17:17:42 ===
SQL Express Error Cannot Show Requested Dialog, And Missing Tables
Dec 30, 2005Two of my databases are still listed under the "Database" folder in SQL Express, yet all objects are now gone. Tried detach/attach and says it works OK - yet no tables, etc.
The odd thing is that I CAN access the tables from Visual C++ Express, and all looks well (data, etc).
When I look at Properties for one of the DBs, and then click on "View Connection Properties" under the "Options" section, the error message pops up:
"Cannot show requested dialog.----------------------------
ADDITIONAL INFORMATION:
Could not load file or assembly 'file:///C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlManagerUi.dll' or one of its dependencies. The system cannot find the file specified. (mscorlib) ".
/////////////////////////////////////////////////////////////////////////////////
Also still throwing an error upon startup, "Unhandled exception has occurred in a component in your application. If you click continue the application will ignore this error...Cannot create a stable subkey under a volatile parent"
Clues?
Thanks
S
PS It would help to enable right click Copy and Paste in this forum -
Why Does Error Log Show Database Restarting Everytime A Transactionlog Backup Runs?
Feb 11, 2008Why does Error log show database restarting everytime a transactionlog backup runs?It also runs a checkdb as well.The log backups are scheduled through a maintenance plan.Is this normal?
View 1 Replies View RelatedTrying To Get Last Ten Clients
May 29, 2008I'm trying to get the last ten unique clients viewed by each user. I have tried using the TOP (N) but it does not show the last ten just any ten.
When a user views a client record, a record is saved to the tblUserRecentViewedClients table and includes logID (key), client_id (int), username (nvarchar), lastviewed (datetime).
Here is what I have so far. Can anyone offer any suggestions?SELECT TOP (10) tblUserRecentViewedClients.UserName, tblUserRecentViewedClients.Client_ID, tblClient.FirstName, tblClient.LastName,
tblClient.CompanyName
FROM tblUserRecentViewedClients INNER JOIN
tblClient ON tblUserRecentViewedClients.client_ID = tblClient.client_ID
WHERE tblUserRecentViewedClients.UserName=@UserName
GROUP BY tblUserRecentViewedClients.UserName, tblUserRecentViewedClients.Client_ID, tblClient.FirstName, tblClient.LastName,
tblClient.CompanyName
Do You Need The Clients
Jan 15, 2004If i use sql server as my backend and microsoft access as my frontend do i need to purchase client access lisences??
View 1 Replies View Related