Dear Supports,
I have database written in SQL SERVER 2005 since last two year .Now the Database size become 33MB, and the log file become 450 MB . The log file is too large for me . Do you any know how clear the log file in SQL SERVER 2005 EXPRESS SP2 ?.Thanks
Best Regards,
Channarith Hun
Dear Friends,
Now i am using Sql Server 2005 Express Editon SP2 to store data . Now the log file of this database is too big that use alot of disk space around 500MB . Now i want to clear this log file .do any one know how to clear this log file in the sql server 2005 express edition SP2 .
I hope you all friends will help me to solve this problem .Thanks
Best Regards,
Channarith Hun .
Hello Everyone,
I am trying to restore a bak file which came with code for a tutorial. I think it is safe to restore, but sql server 2005 express has the following problem when I try to restore it.
TITLE: Microsoft SQL Server Management Studio Express------------------------------
Restore failed for Server 'BOBSQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
------------------------------ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:Program Files (x86)Microsoft SQL ServerMSSQL.1MSSQLDashboard.mdf'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476
The links given for help have no information about the problem and I'm not really sure where I should be looking to solve this. I'm a newbie to databases so if you could provide a step-by-step answer that would be best. Thanks in advance.
Robert
Hi All, I have a .sql file with
all my queries written in it. Now I want to know, Is it possible to run
this sql file in SQL Server 2005 Express Edition like we can do in
Oracle? If it is possible then tell me how to do it?Thanx in advance for any kind of help.Regards,Paramhans Dubey.
Hi Guys, how many connections does sql 2005 express allow to .mdf file. I stumpled on info on a microsoft site (actually a forum post on msdn) that sql server express allows only a single connection to an .mdf file.
Iam intrested in this because i developed reporting services reports in BIS and iam having problems. If i run a report from report manager, i have to wait for close to 20 minutes before i can be able to run my asp.net application agian. Else if i insert data or retrieve data from my asp.net application, then i have to wait again for 20 minutes or more before i can be able to run my reports else i will get an error that a connection can not be made to the database or that the database is being used by another process.
So in all cases, i have to wait for 20--30 minutes before a connection can be made to the .mdf file. i.e after running a report or after inserting or retrieving data from the database through my asp.net application.
Iam using sql sever 2005 express with advanced services and visual web developer on windows server 2003.
Any ideas or help.
All --
Please help.
Is it possible to connect to MDF file without having SQL Server 2005 Express installed on the machine?
That is-- can one connect directly to an MDF in the same way and Access MDB file can be used?
If no, then is there any way around this?
If yes, then are there any limitations?
Please advise.
Thank you.
-- Mark Kamoski
I am new to SQL Server, and migrating part of an Access application toSSE. I am trying to insert a comma delimited file into SSE 2005. I amable to run a BULK INSERT statement on a simple file, specifying thefield (,) and row () terminators. I can also do the same with aformat file.Here is the problem. My csv file has 185 columns, with a mixture ofdatatypes. Sometimes, a text field will contain the field delimiter aspart of the string. In this case (and only in this case) there will bedouble quotes around the string to indicate that the comma is part ofthe field, and not a delimiter.Is there any way to indicate that there is a text delimiter that isonly present some of the time?If not, any suggestions on getting the data into SSE?Many thanks for your input.Cheryl
View 9 Replies View RelatedI attached a SQL database called Cars, using the following code:
Code Block
IF NOT EXISTS(
SELECT *
FROM sys.databases
WHERE name = N'Cars'
)
CREATE DATABASE Cars
ON PRIMARY (FILENAME = 'C:DataServer FilesCars.mdf')
FOR ATTACH
GO
I then detached the database using:
Code Block
EXEC sp_detach_db @dbname = 'Cars'
,@skipchecks = 'true'
,@KeepFulltextIndexFile = 'true'
GO
I then copied the .mdf and .ldf to another folder, using Windows Explorer.
I then attached the database using the new folder name in my code.:
Code Block
IF NOT EXISTS(
SELECT *
FROM sys.databases
WHERE name = N'Cars'
)
CREATE DATABASE Cars
ON PRIMARY (FILENAME = 'C:DataNew FolderCars.mdf')
FOR ATTACH
GO
Now when I go to update my table, I see that I am hitting the .mdf in the new folder.
And, when I do my table updates, I see that I am hitting the .ldf in the old folder.
Two questions:
1. What did I do wrong, that updates are hitting the new .mdf, but the old .ldf?
2. How do I control what .ldf SQL Express uses?
I see references to 'SQL Server Agent' in the help pages, but do not see 'SQL Server Agent' within the application.
I see the reference to the old folder path, within the 'Database Properties Files page', but no possibity to edit the value.
Hello, I have correctly installed sql express 2005 onto my company server. I can connect to the sql express 2005 fine within sql management studio express. I can also connect to it the within visual studio 2005 server explorer. I have my database (MDF) on our server. I am trying to run my application within my client computer. I have changed the connection string property to connect to the server:
"Data Source=CTSSQLEXPRESS;Initial Catalog=UpdateAttributes;Integrated Security=True"
My program will only work if there is a local copy of MDF database located within my application directory. If I remove the local copy, it errors "No process is on the other end of the pipe" Is it possible to have my application without the local copy of the MDF? I thought the idea is to have the MDF on the server. Then my app would not have the MDF copy!?
what is the command using to clear the content of log file
View 2 Replies View RelatedI need to transfer dbf file to sql server 2005 express edition with some periodic interval. Can any one please recommend which is the easiest and efficient method to do?. Like polling every 5 to 10 seconds transfer data to sql server 2005 ex edition.
Is it recommend to do it visual basic program?, how to do it. pls help
=== Verbose logging started: 8/16/2006 8:56:23 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: c:faca48e439bf4182f2bd96setup.exe ===
MSI (c) (98:00) [08:56:23:850]: Resetting cached policy values
MSI (c) (98:00) [08:56:23:850]: Machine policy value 'Debug' is 0
MSI (c) (98:00) [08:56:23:850]: ******* RunEngine:
******* Product: c:faca48e439bf4182f2bd96SetupSqlSupport.msi
******* Action:
******* CommandLine: **********
MSI (c) (98:00) [08:56:23:850]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (98:00) [08:56:23:850]: Grabbed execution mutex.
MSI (c) (98:00) [08:56:23:850]: Cloaking enabled.
MSI (c) (98:00) [08:56:23:850]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (98:00) [08:56:23:860]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (70:58) [08:56:23:870]: Grabbed execution mutex.
MSI (s) (70:FC) [08:56:23:870]: Resetting cached policy values
MSI (s) (70:FC) [08:56:23:870]: Machine policy value 'Debug' is 0
MSI (s) (70:FC) [08:56:23:870]: ******* RunEngine:
******* Product: c:faca48e439bf4182f2bd96SetupSqlSupport.msi
******* Action:
******* CommandLine: **********
MSI (s) (70:FC) [08:56:23:870]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (70:FC) [08:56:23:870]: File will have security applied from OpCode.
MSI (s) (70:FC) [08:56:23:920]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'c:faca48e439bf4182f2bd96SetupSqlSupport.msi' against software restriction policy
MSI (s) (70:FC) [08:56:23:920]: SOFTWARE RESTRICTION POLICY: c:faca48e439bf4182f2bd96SetupSqlSupport.msi has a digital signature
MSI (s) (70:FC) [08:56:23:990]: SOFTWARE RESTRICTION POLICY: c:faca48e439bf4182f2bd96SetupSqlSupport.msi is permitted to run at the 'unrestricted' authorization level.
MSI (s) (70:FC) [08:56:23:990]: End dialog not enabled
MSI (s) (70:FC) [08:56:23:990]: Original package ==> c:faca48e439bf4182f2bd96SetupSqlSupport.msi
MSI (s) (70:FC) [08:56:23:990]: Package we're running from ==> c:WINDOWSInstaller4e59e6d.msi
MSI (s) (70:FC) [08:56:23:990]: APPCOMPAT: looking for appcompat database entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'.
MSI (s) (70:FC) [08:56:23:990]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (70:FC) [08:56:23:990]: MSCOREE already loaded, using loaded copy
MSI (s) (70:FC) [08:56:24:000]: Machine policy value 'TransformsSecure' is 0
MSI (s) (70:FC) [08:56:24:000]: User policy value 'TransformsAtSource' is 0
MSI (s) (70:FC) [08:56:24:000]: Machine policy value 'DisablePatch' is 0
MSI (s) (70:FC) [08:56:24:000]: Machine policy value 'AllowLockdownPatch' is 0
MSI (s) (70:FC) [08:56:24:000]: Machine policy value 'DisableLUAPatching' is 0
MSI (s) (70:FC) [08:56:24:000]: Machine policy value 'DisableFlyWeightPatching' is 0
MSI (s) (70:FC) [08:56:24:000]: APPCOMPAT: looking for appcompat database entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'.
MSI (s) (70:FC) [08:56:24:000]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (70:FC) [08:56:24:000]: Transforms are not secure.
MSI (s) (70:FC) [08:56:24:000]: Note: 1: 2205 2: 3: Control
MSI (s) (70:FC) [08:56:24:000]: Command Line: ADDLOCAL=All REINSTALLMODE=vomus REBOOT=ReallySuppress CURRENTDIRECTORY=c:faca48e439bf4182f2bd96 CLIENTUILEVEL=3 CLIENTPROCESSID=2712
MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{EE7DF8EF-0E50-44E1-9603-0E4FD66A993D}'.
MSI (s) (70:FC) [08:56:24:000]: Product Code passed to Engine.Initialize: ''
MSI (s) (70:FC) [08:56:24:000]: Product Code from property table before transforms: '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'
MSI (s) (70:FC) [08:56:24:000]: Product Code from property table after transforms: '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'
MSI (s) (70:FC) [08:56:24:000]: Product not registered: beginning first-time install
MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding ProductState property. Its value is '-1'.
MSI (s) (70:FC) [08:56:24:000]: Entering CMsiConfigurationManager::SetLastUsedSource.
MSI (s) (70:FC) [08:56:24:000]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (70:FC) [08:56:24:000]: Adding new sources is allowed.
MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding PackagecodeChanging property. Its value is '1'.
MSI (s) (70:FC) [08:56:24:000]: Package name extracted from package path: 'SqlSupport.msi'
MSI (s) (70:FC) [08:56:24:000]: Package to be registered: 'sqlsupport.msi'
MSI (s) (70:FC) [08:56:24:000]: Note: 1: 2262 2: AdminProperties 3: -2147287038
MSI (s) (70:FC) [08:56:24:000]: Machine policy value 'DisableMsi' is 0
MSI (s) (70:FC) [08:56:24:000]: Machine policy value 'AlwaysInstallElevated' is 0
MSI (s) (70:FC) [08:56:24:000]: User policy value 'AlwaysInstallElevated' is 0
MSI (s) (70:FC) [08:56:24:000]: Product installation will be elevated because user is admin and product is being installed per-machine.
MSI (s) (70:FC) [08:56:24:000]: Running product '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}' with elevated privileges: Product is assigned.
MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'All'.
MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding REINSTALLMODE property. Its value is 'vomus'.
MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding REBOOT property. Its value is 'ReallySuppress'.
MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding CURRENTDIRECTORY property. Its value is 'c:faca48e439bf4182f2bd96'.
MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding CLIENTUILEVEL property. Its value is '3'.
MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding CLIENTPROCESSID property. Its value is '2712'.
MSI (s) (70:FC) [08:56:24:000]: TRANSFORMS property is now:
MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding VersionDatabase property. Its value is '200'.
MSI (s) (70:FC) [08:56:24:000]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHApplication Data
MSI (s) (70:FC) [08:56:24:000]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHFavorites
MSI (s) (70:FC) [08:56:24:000]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHNetHood
MSI (s) (70:FC) [08:56:24:010]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHMy Documents
MSI (s) (70:FC) [08:56:24:010]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHPrintHood
MSI (s) (70:FC) [08:56:24:010]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHRecent
MSI (s) (70:FC) [08:56:24:010]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHSendTo
MSI (s) (70:FC) [08:56:24:010]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHTemplates
MSI (s) (70:FC) [08:56:24:010]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersApplication Data
MSI (s) (70:FC) [08:56:24:010]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHLocal SettingsApplication Data
MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHMy DocumentsMy Pictures
MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsAdministrative Tools
MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsStartup
MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuPrograms
MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart Menu
MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersDesktop
MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHStart MenuProgramsAdministrative Tools
MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHStart MenuProgramsStartup
MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHStart MenuPrograms
MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHStart Menu
MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHDesktop
MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersTemplates
MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:WINDOWSFonts
MSI (s) (70:FC) [08:56:24:020]: Note: 1: 2898 2: MS Sans Serif 3: MS Sans Serif 4: 0 5: 16
MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding Privileged property. Its value is '1'.
MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding USERNAME property. Its value is ' '.
MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding COMPANYNAME property. Its value is ' '.
MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding DATABASE property. Its value is 'c:WINDOWSInstaller4e59e6d.msi'.
MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding OriginalDatabase property. Its value is 'c:faca48e439bf4182f2bd96SetupSqlSupport.msi'.
MSI (s) (70:FC) [08:56:24:030]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (70:FC) [08:56:24:030]: Machine policy value 'DisableRollback' is 0
MSI (s) (70:FC) [08:56:24:030]: User policy value 'DisableRollback' is 0
MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding UILevel property. Its value is '2'.
=== Logging started: 8/16/2006 8:56:24 ===
MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding Preselected property. Its value is '1'.
MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding ACTION property. Its value is 'INSTALL'.
MSI (s) (70:FC) [08:56:24:030]: Doing action: INSTALL
MSI (s) (70:FC) [08:56:24:030]: Running ExecuteSequence
MSI (s) (70:FC) [08:56:24:030]: Doing action: CommonFilesFolder.DCA909F7_1890_4AD6_9EAE_3C9D956FE00B
Action start 8:56:24: INSTALL.
MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding CommonFilesFolder.DCA909F7_1890_4AD6_9EAE_3C9D956FE00B property. Its value is 'C:Program FilesCommon Files'.
Action start 8:56:24: CommonFilesFolder.DCA909F7_1890_4AD6_9EAE_3C9D956FE00B.
MSI (s) (70:FC) [08:56:24:030]: Doing action: LocalAppDataFolder.D0DF3458_A845_11D3_8D0A_0050046416B9
Action ended 8:56:24: CommonFilesFolder.DCA909F7_1890_4AD6_9EAE_3C9D956FE00B. Return value 1.
MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding LocalAppDataFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'C:Documents and SettingsRickHLocal SettingsApplication Data'.
Action start 8:56:24: LocalAppDataFolder.D0DF3458_A845_11D3_8D0A_0050046416B9.
MSI (s) (70:FC) [08:56:24:030]: Doing action: WindowsFolder.D0DF3458_A845_11D3_8D0A_0050046416B9
Action ended 8:56:24: LocalAppDataFolder.D0DF3458_A845_11D3_8D0A_0050046416B9. Return value 1.
MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding WindowsFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'C:WINDOWS'.
Action start 8:56:24: WindowsFolder.D0DF3458_A845_11D3_8D0A_0050046416B9.
MSI (s) (70:FC) [08:56:24:030]: Doing action: ProgramFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9
Action ended 8:56:24: WindowsFolder.D0DF3458_A845_11D3_8D0A_0050046416B9. Return value 1.
MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding ProgramFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'C:Program Files'.
Action start 8:56:24: ProgramFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9.
MSI (s) (70:FC) [08:56:24:030]: Doing action: CommonFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9
Action ended 8:56:24: ProgramFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9. Return value 1.
MSI (s) (70:FC) [08:56:24:040]: PROPERTY CHANGE: Adding CommonFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'C:Program FilesCommon Files'.
Action start 8:56:24: CommonFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9.
MSI (s) (70:FC) [08:56:24:040]: Doing action: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E
Action ended 8:56:24: CommonFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9. Return value 1.
MSI (s) (70:FC) [08:56:24:040]: PROPERTY CHANGE: Adding WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'.
Action start 8:56:24: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E.
MSI (s) (70:FC) [08:56:24:040]: Doing action: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E
Action ended 8:56:24: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (70:FC) [08:56:24:040]: PROPERTY CHANGE: Adding SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'.
Action start 8:56:24: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E.
MSI (s) (70:FC) [08:56:24:040]: Doing action: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E
Action ended 8:56:24: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (70:FC) [08:56:24:040]: PROPERTY CHANGE: Adding WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'.
Action start 8:56:24: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E.
MSI (s) (70:FC) [08:56:24:040]: Doing action: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E
Action ended 8:56:24: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (70:FC) [08:56:24:040]: PROPERTY CHANGE: Adding SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'.
Action start 8:56:24: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E.
MSI (s) (70:FC) [08:56:24:040]: Doing action: LaunchConditions
Action ended 8:56:24: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (70:FC) [08:56:24:040]: Note: 1: 2205 2: 3: LaunchCondition
MSI (s) (70:FC) [08:56:24:040]: Note: 1: 2228 2: 3: LaunchCondition 4: SELECT `Condition`, `Description` FROM `LaunchCondition`
Action start 8:56:24: LaunchConditions.
MSI (s) (70:FC) [08:56:24:040]: Doing action: FindRelatedProducts
Action ended 8:56:24: LaunchConditions. Return value 0.
MSI (s) (70:FC) [08:56:24:040]: Note: 1: 2205 2: 3: Upgrade
MSI (s) (70:FC) [08:56:24:040]: Note: 1: 2228 2: 3: Upgrade 4: SELECT `UpgradeCode`,`VersionMin`,`VersionMax`,`Language`,`Attributes`,`ActionProperty` FROM `Upgrade`
Action start 8:56:24: FindRelatedProducts.
MSI (s) (70:FC) [08:56:24:040]: Skipping action: Sqlmsirc_ValidateAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (70:FC) [08:56:24:040]: Skipping action: Sqlmsirc_RefCountAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (70:FC) [08:56:24:040]: Skipping action: Sqlmsirc_BackupAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (70:FC) [08:56:24:040]: Skipping action: Sqlmsirc_RegisterAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (70:FC) [08:56:24:040]: Skipping action: Sqlmsirc_RestoreAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (70:FC) [08:56:24:040]: Doing action: AppSearch
Action ended 8:56:24: FindRelatedProducts. Return value 0.
MSI (s) (70:FC) [08:56:24:050]: Note: 1: 2205 2: 3: AppSearch
MSI (s) (70:FC) [08:56:24:050]: Note: 1: 2228 2: 3: AppSearch 4: SELECT `Property`, `Signature_` FROM `AppSearch`
Action start 8:56:24: AppSearch.
MSI (s) (70:FC) [08:56:24:050]: Doing action: CCPSearch
Action ended 8:56:24: AppSearch. Return value 0.
MSI (s) (70:FC) [08:56:24:050]: Note: 1: 2205 2: 3: CCPSearch
MSI (s) (70:FC) [08:56:24:050]: Note: 1: 2228 2: 3: CCPSearch 4: SELECT `Signature_` FROM `CCPSearch`
Action start 8:56:24: CCPSearch.
MSI (s) (70:FC) [08:56:24:050]: Doing action: RMCCPSearch
Action ended 8:56:24: CCPSearch. Return value 0.
MSI (s) (70:FC) [08:56:24:050]: Note: 1: 2205 2: 3: CCPSearch
MSI (s) (70:FC) [08:56:24:050]: Note: 1: 2228 2: 3: CCPSearch 4: SELECT `Signature_` FROM `CCPSearch`
Action start 8:56:24: RMCCPSearch.
MSI (s) (70:FC) [08:56:24:050]: Skipping action: Sqlmsirc_CheckLanguage.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (70:FC) [08:56:24:050]: Doing action: CostInitialize
Action ended 8:56:24: RMCCPSearch. Return value 0.
MSI (s) (70:FC) [08:56:24:050]: Machine policy value 'MaxPatchCacheSize' is 10
Action start 8:56:24: CostInitialize.
MSI (s) (70:FC) [08:56:24:080]: PROPERTY CHANGE: Adding ROOTDRIVE property. Its value is 'c:'.
MSI (s) (70:FC) [08:56:24:080]: PROPERTY CHANGE: Adding CostingComplete property. Its value is '0'.
MSI (s) (70:FC) [08:56:24:080]: Note: 1: 2205 2: 3: Patch
MSI (s) (70:FC) [08:56:24:080]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (70:FC) [08:56:24:080]: Note: 1: 2205 2: 3: MsiPatchHeaders
MSI (s) (70:FC) [08:56:24:080]: Note: 1: 2205 2: 3: __MsiPatchFileList
MSI (s) (70:FC) [08:56:24:080]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (70:FC) [08:56:24:080]: Note: 1: 2228 2: 3: PatchPackage 4: SELECT `DiskId`, `PatchId`, `LastSequence` FROM `Media`, `PatchPackage` WHERE `Media`.`DiskId`=`PatchPackage`.`Media_` ORDER BY `DiskId`
MSI (s) (70:FC) [08:56:24:080]: Doing action: FileCost
Action ended 8:56:24: CostInitialize. Return value 1.
MSI (s) (70:FC) [08:56:24:090]: Note: 1: 2262 2: Class 3: -2147287038
MSI (s) (70:FC) [08:56:24:090]: Note: 1: 2262 2: Extension 3: -2147287038
MSI (s) (70:FC) [08:56:24:090]: Note: 1: 2262 2: TypeLib 3: -2147287038
Action start 8:56:24: FileCost.
MSI (s) (70:FC) [08:56:24:090]: Doing action: IsolateComponents
Action ended 8:56:24: FileCost. Return value 1.
Action start 8:56:24: IsolateComponents.
MSI (s) (70:FC) [08:56:24:090]: Doing action: CostFinalize
Action ended 8:56:24: IsolateComponents. Return value 0.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding OutOfDiskSpace property. Its value is '0'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding OutOfNoRbDiskSpace property. Its value is '0'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceAvailable property. Its value is '0'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceRequired property. Its value is '0'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceRemaining property. Its value is '0'.
MSI (s) (70:FC) [08:56:24:090]: Note: 1: 2205 2: 3: Patch
MSI (s) (70:FC) [08:56:24:090]: Note: 1: 2262 2: Condition 3: -2147287038
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding TARGETDIR property. Its value is 'c:'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying TempFolder property. Its current value is 'C:DOCUME~1RickHLOCALS~1Temp'. Its new value: 'c:DOCUME~1RickHLOCALS~1Temp'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying WindowsFolder property. Its current value is 'C:WINDOWS'. Its new value: 'c:WINDOWS'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying CommonFilesFolder.DCA909F7_1890_4AD6_9EAE_3C9D956FE00B property. Its current value is 'C:Program FilesCommon Files'. Its new value: 'c:Program FilesCommon Files'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying LocalAppDataFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its current value is 'C:Documents and SettingsRickHLocal SettingsApplication Data'. Its new value: 'c:Documents and SettingsRickHLocal SettingsApplication Data'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding LocalAppDataPCHealth.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTH'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding LocalAppDataErrorReporting.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREP'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WatsonUQSignoffFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREPQSIGNOFF'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WatsonUQRegularFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREPQREGULAR'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WatsonUQHeadlessFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREPQHEADLES'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying ProgramFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its current value is 'C:Program Files'. Its new value: 'c:Program Files'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying CommonFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its current value is 'C:Program FilesCommon Files'. Its new value: 'c:Program FilesCommon Files'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding SharedFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Program FilesCommon FilesMicrosoft Shared'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding DWFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Program FilesCommon FilesMicrosoft SharedDW'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding DWIntlFolder_1033.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Program FilesCommon FilesMicrosoft SharedDW1033'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying WindowsFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its current value is 'C:WINDOWS'. Its new value: 'c:WINDOWS'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WindowsPCHealth.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:WINDOWSPCHEALTH'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WindowsErrorReporting.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:WINDOWSPCHEALTHERRORREP'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WatsonAQSignoffFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:WINDOWSPCHEALTHERRORREPQSIGNOFF'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WatsonAQHeadlessFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:WINDOWSPCHEALTHERRORREPQHEADLES'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WindowsINFFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:WINDOWSINF'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its current value is 'C:WINDOWS'. Its new value: 'c:WINDOWS'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its current value is 'C:WINDOWSsystem32'. Its new value: 'c:WINDOWSsystem32'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WinSxsDirectory.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxs'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding policydir_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding payload.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WinSxsManifests.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsManifests'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WinSxsPolicies.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsPolicies'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding policydir.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsPoliciesx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_77c24773'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding payload_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsx86_policy.8.0.microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_5c4003bc63e949f6'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its current value is 'C:WINDOWS'. Its new value: 'c:WINDOWS'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its current value is 'C:WINDOWSsystem32'. Its new value: 'c:WINDOWSsystem32'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WinSxsDirectory.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxs'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding policydir_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WinSxsPolicies.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsPolicies'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding policydir.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsPoliciesx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_4428b63a'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WinSxsManifests.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsManifests'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding payload_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsx86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_db5f52fb98cb24ad'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying ProgramFilesFolder property. Its current value is 'C:Program Files'. Its new value: 'c:Program Files'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding INSTALLSQLDIR property. Its value is 'c:Program FilesMicrosoft SQL Server'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Ver.EF99D297_8F3F_42F1_8766_460250F41CDA property. Its value is 'c:Program FilesMicrosoft SQL Server90'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding InstallDir.EF99D297_8F3F_42F1_8766_460250F41CDA property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup Bootstrap'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPA.EF99D297_8F3F_42F1_8766_460250F41CDA property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARes1033.EF99D297_8F3F_42F1_8766_460250F41CDA property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA1033'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding SqlVer.41746B4B_478E_4AF6_946E_774617467ABF property. Its value is 'c:Program FilesMicrosoft SQL Server90'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding INSTALLDIR.41746B4B_478E_4AF6_946E_774617467ABF property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup Bootstrap'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPA.41746B4B_478E_4AF6_946E_774617467ABF property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding SqlVer.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding INSTALLDIR.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup Bootstrap'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPA.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPASchemas.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPASchemas'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepository.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepository'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryDBUNWRI.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDBUNWRITABLE_UPGBLKR'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinDBUNWRI.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDBUNWRITABLE_UPGBLKRin'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryYukUPBlock.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryYUK1_UPGBLKR'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinYukUPBlock.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryYUK1_UPGBLKRin'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryRSDIIS.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIIS'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinRSDIIS.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIISin'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryRSCA.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMASSEMBLIES'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinRSCA.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMASSEMBLIESin'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryResDBID.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRESERVEDATABASEID'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinResDBID.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRESERVEDATABASEIDin'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryLogin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryLOGINNAMEASSERVERROLE'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinLogin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryLOGINNAMEASSERVERROLEin'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryDUPSid.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATESID'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinDUPSid.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATESIDin'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryDUPIdx.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATEINDEX_UPGBLKR'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinDUPIdx.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATEINDEX_UPGBLKRin'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryASP.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryASPNETUSERENCRYPTED'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinASP.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryASPNETUSERENCRYPTEDin'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding RSDEFAULTIISYUKON.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIISYUKON'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding RSDEFAULTIISYUKON_bin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIISYUKONin'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding RSCUSTOMSECURITY.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMSECURITY'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding RSCUSTOMSECURITY_bin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMSECURITYin'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPAbin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPAin'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Ver.741C00B4_26BA_4E42_B590_3D7E63AF2EC4 property. Its value is 'c:Program FilesMicrosoft SQL Server90'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Gac.741C00B4_26BA_4E42_B590_3D7E63AF2EC4 property. Its value is 'c:Program FilesMicrosoft SQL Server90GAC'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Ver.117A1A21_ACE1_414A_88CC_83C84195F101 property. Its value is 'c:Program FilesMicrosoft SQL Server90'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Gac.117A1A21_ACE1_414A_88CC_83C84195F101 property. Its value is 'c:Program FilesMicrosoft SQL Server90GAC'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Ver.4845A713_8D8A_4100_8CAA_164C5AC9E452 property. Its value is 'c:Program FilesMicrosoft SQL Server90'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Gac.4845A713_8D8A_4100_8CAA_164C5AC9E452 property. Its value is 'c:Program FilesMicrosoft SQL Server90GAC'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Ver.3512ABB7_9344_4EF4_BCF5_984E466B5161 property. Its value is 'c:Program FilesMicrosoft SQL Server90'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Gac.3512ABB7_9344_4EF4_BCF5_984E466B5161 property. Its value is 'c:Program FilesMicrosoft SQL Server90GAC'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Ver.476E40C2_BF50_44F5_B79F_85F11E8470B6 property. Its value is 'c:Program FilesMicrosoft SQL Server90'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Gac.476E40C2_BF50_44F5_B79F_85F11E8470B6 property. Its value is 'c:Program FilesMicrosoft SQL Server90GAC'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding SqlVer.8DFD65FF_E015_42C8_B398_112982807348 property. Its value is 'c:Program FilesMicrosoft SQL Server90'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding SqlVer.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08 property. Its value is 'c:Program FilesMicrosoft SQL Server90'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding INSTALLDIR property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup Bootstrap'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding finish1033.8DFD65FF_E015_42C8_B398_112982807348 property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup Bootstrap1033'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding RES.8DFD65FF_E015_42C8_B398_112982807348 property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapResources'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Res11033.8DFD65FF_E015_42C8_B398_112982807348 property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapResources1033'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Help.8DFD65FF_E015_42C8_B398_112982807348 property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapHelp'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Res21033.8DFD65FF_E015_42C8_B398_112982807348 property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapHelp1033'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding SETUPBIN property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBin'.
MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding SETUPLOG property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapLog'.
MSI (s) (70:FC) [08:56:24:090]: Target path resolution complete. Dumping Directory table...
MSI (s) (70:FC) [08:56:24:090]: Note: target paths subject to change (via custom actions or browsing)
MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: TARGETDIR , Object: c:
MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: TempFolder , Object: c:DOCUME~1RickHLOCALS~1Temp
MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: WindowsFolder , Object: c:WINDOWS
MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: CommonFilesFolder.DCA909F7_1890_4AD6_9EAE_3C9D956FE00B , Object: c:Program FilesCommon Files
MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: LocalAppDataFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Documents and SettingsRickHLocal SettingsApplication Data
MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: LocalAppDataPCHealth.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTH
MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: LocalAppDataErrorReporting.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREP
MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: WatsonUQSignoffFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREPQSIGNOFF
MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: WatsonUQRegularFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREPQREGULAR
MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: WatsonUQHeadlessFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREPQHEADLES
MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: ProgramFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Program Files
MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: CommonFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Program FilesCommon Files
MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: SharedFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Program FilesCommon FilesMicrosoft Shared
MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: DWFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Program FilesCommon FilesMicrosoft SharedDW
MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: DWIntlFolder_1033.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Program FilesCommon FilesMicrosoft SharedDW1033
MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: WindowsFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:WINDOWS
MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: WindowsPCHealth.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:WINDOWSPCHEALTH
MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: WindowsErrorReporting.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:WINDOWSPCHEALTHERRORREP
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WatsonAQSignoffFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:WINDOWSPCHEALTHERRORREPQSIGNOFF
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WatsonAQHeadlessFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:WINDOWSPCHEALTHERRORREPQHEADLES
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WindowsINFFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:WINDOWSINF
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWS
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWSsystem32
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WinSxsDirectory.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxs
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: policydir_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: payload.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WinSxsManifests.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsManifests
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WinSxsPolicies.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsPolicies
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: policydir.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsPoliciesx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_77c24773
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: payload_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsx86_policy.8.0.microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_5c4003bc63e949f6
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWS
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWSsystem32
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WinSxsDirectory.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxs
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: policydir_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WinSxsPolicies.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsPolicies
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: policydir.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsPoliciesx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_4428b63a
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WinSxsManifests.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsManifests
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: payload_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsx86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_db5f52fb98cb24ad
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: ProgramFilesFolder , Object: c:Program Files
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: INSTALLSQLDIR , Object: c:Program FilesMicrosoft SQL Server
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Ver.EF99D297_8F3F_42F1_8766_460250F41CDA , Object: c:Program FilesMicrosoft SQL Server90
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: InstallDir.EF99D297_8F3F_42F1_8766_460250F41CDA , Object: c:Program FilesMicrosoft SQL Server90Setup Bootstrap
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPA.EF99D297_8F3F_42F1_8766_460250F41CDA , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARes1033.EF99D297_8F3F_42F1_8766_460250F41CDA , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA1033
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SqlVer.41746B4B_478E_4AF6_946E_774617467ABF , Object: c:Program FilesMicrosoft SQL Server90
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: INSTALLDIR.41746B4B_478E_4AF6_946E_774617467ABF , Object: c:Program FilesMicrosoft SQL Server90Setup Bootstrap
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPA.41746B4B_478E_4AF6_946E_774617467ABF , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SqlVer.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: INSTALLDIR.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup Bootstrap
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPA.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPASchemas.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPASchemas
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepository.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepository
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryDBUNWRI.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDBUNWRITABLE_UPGBLKR
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinDBUNWRI.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDBUNWRITABLE_UPGBLKRin
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryYukUPBlock.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryYUK1_UPGBLKR
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinYukUPBlock.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryYUK1_UPGBLKRin
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryRSDIIS.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIIS
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinRSDIIS.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIISin
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryRSCA.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMASSEMBLIES
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinRSCA.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMASSEMBLIESin
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryResDBID.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRESERVEDATABASEID
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinResDBID.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRESERVEDATABASEIDin
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryLogin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryLOGINNAMEASSERVERROLE
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinLogin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryLOGINNAMEASSERVERROLEin
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryDUPSid.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATESID
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinDUPSid.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATESIDin
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryDUPIdx.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATEINDEX_UPGBLKR
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinDUPIdx.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATEINDEX_UPGBLKRin
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryASP.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryASPNETUSERENCRYPTED
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinASP.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryASPNETUSERENCRYPTEDin
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: RSDEFAULTIISYUKON.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIISYUKON
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: RSDEFAULTIISYUKON_bin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIISYUKONin
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: RSCUSTOMSECURITY.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMSECURITY
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: RSCUSTOMSECURITY_bin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMSECURITYin
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPAbin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPAin
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Ver.741C00B4_26BA_4E42_B590_3D7E63AF2EC4 , Object: c:Program FilesMicrosoft SQL Server90
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Gac.741C00B4_26BA_4E42_B590_3D7E63AF2EC4 , Object: c:Program FilesMicrosoft SQL Server90GAC
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Ver.117A1A21_ACE1_414A_88CC_83C84195F101 , Object: c:Program FilesMicrosoft SQL Server90
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Gac.117A1A21_ACE1_414A_88CC_83C84195F101 , Object: c:Program FilesMicrosoft SQL Server90GAC
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Ver.4845A713_8D8A_4100_8CAA_164C5AC9E452 , Object: c:Program FilesMicrosoft SQL Server90
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Gac.4845A713_8D8A_4100_8CAA_164C5AC9E452 , Object: c:Program FilesMicrosoft SQL Server90GAC
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Ver.3512ABB7_9344_4EF4_BCF5_984E466B5161 , Object: c:Program FilesMicrosoft SQL Server90
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Gac.3512ABB7_9344_4EF4_BCF5_984E466B5161 , Object: c:Program FilesMicrosoft SQL Server90GAC
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Ver.476E40C2_BF50_44F5_B79F_85F11E8470B6 , Object: c:Program FilesMicrosoft SQL Server90
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Gac.476E40C2_BF50_44F5_B79F_85F11E8470B6 , Object: c:Program FilesMicrosoft SQL Server90GAC
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SqlVer.8DFD65FF_E015_42C8_B398_112982807348 , Object: c:Program FilesMicrosoft SQL Server90
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SqlVer.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08 , Object: c:Program FilesMicrosoft SQL Server90
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: INSTALLDIR , Object: c:Program FilesMicrosoft SQL Server90Setup Bootstrap
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: finish1033.8DFD65FF_E015_42C8_B398_112982807348 , Object: c:Program FilesMicrosoft SQL Server90Setup Bootstrap1033
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: RES.8DFD65FF_E015_42C8_B398_112982807348 , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapResources
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Res11033.8DFD65FF_E015_42C8_B398_112982807348 , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapResources1033
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Help.8DFD65FF_E015_42C8_B398_112982807348 , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapHelp
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Res21033.8DFD65FF_E015_42C8_B398_112982807348 , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapHelp1033
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SETUPBIN , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBin
MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SETUPLOG , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapLog
MSI (s) (70:FC) [08:56:24:100]: PROPERTY CHANGE: Adding INSTALLLEVEL property. Its value is '1'.
MSI (s) (70:FC) [08:56:24:100]: Disallowing installation of component: {1A6D8713-9116-44AE-BA60-4CF0E8C1D58B} since the same component with higher versioned keyfile exists
Action start 8:56:24: CostFinalize.
MSI (s) (70:FC) [08:56:24:120]: Doing action: ARPInstallLocation.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08
Action ended 8:56:24: CostFinalize. Return value 1.
MSI (s) (70:FC) [08:56:24:120]: PROPERTY CHANGE: Adding ARPINSTALLLOCATION property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup Bootstrap'.
Action start 8:56:24: ARPInstallLocation.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08.
MSI (s) (70:FC) [08:56:24:120]: Doing action: SetODBCFolders
Action ended 8:56:24: ARPInstallLocation.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08. Return value 1.
MSI (s) (70:FC) [08:56:24:120]: Note: 1: 2205 2: 3: ODBCDriver
MSI (s) (70:FC) [08:56:24:120]: Note: 1: 2228 2: 3: ODBCDriver 4: SELECT `ComponentId`,`Description`,`Directory_`, `ActionRequest`, `Installed`, `Attributes` FROM `ODBCDriver`, `Component` WHERE `ODBCDriver`.`Component_` = `Component` AND (`ActionRequest` = 1 OR `ActionRequest` = 2)
MSI (s) (70:FC) [08:56:24:120]: Note: 1: 2205 2: 3: ODBCTranslator
MSI (s) (70:FC) [08:56:24:120]: Note: 1: 2228 2: 3: ODBCTranslator 4: SELECT `ComponentId`,`Description`,`Directory_`, `ActionRequest`, `Installed`, `Attributes` FROM `ODBCTranslator`, `Component` WHERE `ODBCTranslator`.`Component_` = `Component` AND (`ActionRequest` = 1 OR `ActionRequest` = 2)
Action start 8:56:24: SetODBCFolders.
MSI (s) (70:FC) [08:56:24:120]: Doing action: MigrateFeatureStates
Action ended 8:56:24: SetODBCFolders. Return value 0.
MSI (s) (70:FC) [08:56:24:120]: Skipping MigrateFeatureStates action: feature settings already made
Action start 8:56:24: MigrateFeatureStates.
MSI (s) (70:FC) [08:56:24:120]: Doing action: InstallValidate
Action ended 8:56:24: MigrateFeatureStates. Return value 0.
MSI (s) (70:FC) [08:56:24:120]: Feature: SupportFiles; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: sqlspars.dll.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: sqlsval.dll.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: DbgHelp.dll.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: setup.exe.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: sqlcu.dll.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: xmlrw.dll.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: ARPWrapper.exe.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: SqlBoot.dll.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: RedistQFEKey.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: CancelAutoplay.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: setupsql9.chm.8DFD65FF_E015_42C8_B398_112982807348; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: sqlspars.rll.8DFD65FF_E015_42C8_B398_112982807348; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: setup.rll.8DFD65FF_E015_42C8_B398_112982807348; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: sqlcu.rll.8DFD65FF_E015_42C8_B398_112982807348; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: ARPWrapper.rll.8DFD65FF_E015_42C8_B398_112982807348; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: finish.txt.8DFD65FF_E015_42C8_B398_112982807348; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: finish_sku.txt.8DFD65FF_E015_42C8_B398_112982807348; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: uplevel.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Absent; Request: Local; Action: Null
MSI (s) (70:FC) [08:56:24:120]: Component: downlevel_manifest.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: downlevel_payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: nosxs.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Absent; Request: Local; Action: Null
MSI (s) (70:FC) [08:56:24:120]: Component: uplevel.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E; Installed: Absent; Request: Local; Action: Null
MSI (s) (70:FC) [08:56:24:120]: Component: downlevel_manifest.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: ExceptionMessageBox.dll.476E40C2_BF50_44F5_B79F_85F11E8470B6; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: WizardFrameworkLite.dll.3512ABB7_9344_4EF4_BCF5_984E466B5161; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: SxSComp.FB6C1C52464E44DC8FDC03E5FCADA0D2; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: SxSComp.65B0CF1C908640AD8A72C6C615216394; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: Microsoft.SqlServer.GridControl.dll.4845A713_8D8A_4100_8CAA_164C5AC9E452; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: Microsoft.SqlServer.Setup.117A1A21_ACE1_414A_88CC_83C84195F101; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: SxSComp.D7B464C2927E4A57AC167006E343B1A1; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: SxSComp.A6AED2EF66B84CCCB5FC3C32CF6E2253; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: MS.Sql.CustomControls.dll.741C00B4_26BA_4E42_B590_3D7E63AF2EC4; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: SxSComp.7CFE79FEC34C4C79B0387EF66E24ECA0; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: SxSComp.A3A47DFCA5F64B03AC400222997E22E9; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: Sql_AsmPublicKeys.6E1C5F41_647A_4340_A91C_FC4906A1EC10; Installed: Absent; Request: Local; Action: Null
MSI (s) (70:FC) [08:56:24:120]: Component: MSS.AnalysisServices.UA.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: MSS.BestPracticesAnalyzer.UA.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: MSS.DTS.UA.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: MSS.NotificationServices.UA.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: MSS.SString.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: MSS.UpgradeAdvisor.UaEngine.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: MSS.UpgradeAdvisor.UaInterface.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: UACmd.exe.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: bpacmd.exe.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: BpaCmdX.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: SQLBPA.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: SQLSORT.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: SQLDATA.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: BPAClient.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: bpacommon.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: BPAdmin.exe.config.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: BPAServer.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: BPLib.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: bpa.RSCUSTOMSECURITY.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: bpa.RSDEFAULTIISYUKON.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: bpa.ASPNETUSERENCRYPTED.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: bpa.DUPLICATEINDEX_UPGBLKR.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: bpa.DUPLICATESID.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: bpa.LOGINNAMEASSERVERROLE.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: bpa.RESERVEDATABASEID.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local
MSI (s) (70:FC) [08:56:24:120]: Component: bpa.RSCUSTOMASSEMBLIES.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request:
I'm experienced using queries to extract data, but I'm new to actually creating tables, except through Access. I work with many records of data, so populating the data by hand is not an option. I created a test database (ValTest) and a test table within that database (ClaimTest). I created a text file (DataTest.txt) with the same layout as I defined for ClaimTest. I want to populate ClaimTest with the data from DataTest.txt. I was told the only way to do that using SQL Server Express was to use a utility called BCP. So I found a page on the Microsoft website talking about BCP. It gave some examples, so I opended up the Command Line window, pointed to the directory that contains the database and text file and typed "BCP ValTest.ClaimTest in DataTest.txt -T -c". I get 3 errors: Named Pipes Provider: Could not open a connection to SQL Server [2], Login timeout expired, and An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
I tried looking around and finding where I could change the settings, in case that was indeed the problem, but was unable to find anything. Does anyone have any suggestions?
Thanks
I want to store a Zip file as a BLOB, but I get an error:
"File 'C:<path of mdf file> ' appears to have been truncated by the operating system. Expected size is 2560KB but actual size is 1536KB "
whenever the BLOB exceeds 1MB.
Any suggestions? How can I store larger .ZIP files to the Database?
I am using MS SQL 2005 Express and the data type that I gave for the column to store Blob is "varbinary(MAX)".
I am inserting byte array in to this field.
It works fine for a zip file less than 1MB but as soon as the zipped file size increases beyond 1MB, lots of error pop-up and then the database is not readable. Its says that, the data in the data base may have been corrupted...
hi
i have a database file backup which is having no extension (eg saims) . Can i create a database using this backup in sql server expression edition.
Or else is there any way to get the .mdf file from sql server 2005 full edition??????????????
Thanx in advance
When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media.
How can apply SQL Server 2005 Express SP1 to update this existing instance?
Currently, if I run this query:
SELECT @@version
I get the following:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
After applying SP1, I should get 9.00.2047.00.
Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1:
http://msdn.microsoft.com/vstudio/express/sql/download/
Thank you,
Bashman
I'm trying to set up a BULK INSERT Format File for some data that I've been sent, which, according to the data documentation, comes in fixed-width format fields (no delimiters except for end-of-row 0D0A) in SQL-Server 2005 Express.
The following is the first line...
"7999163 09182003 56586 56477 3601942 1278 22139 1102 113 118 51450 1 1 63535647 10000
7999162 09182003 56586 56477 3601942 1279 22139 1102 113 118 51450 1 1 63535647 10000 "
Looking with a hex editor, all the above whitespace are 20's.
From the documentation, I've constructed the following table...
CREATE TABLE MQIC.DBO.ORDER_F
(
TRACER_ID NUMERIC (10,0),
DB_CREATE_DATE CHAR (8),
DB_UPDATED_DATE CHAR (8),
CREATE_DATE_KEY NUMERIC (10,0),
ORDER_DATE_KEY NUMERIC (10,0),
PATIENT_KEY NUMERIC (10,0),
ORDER_KEY NUMERIC (10,0),
PROVIDER_KEY NUMERIC (10,0),
LOCATION_KEY NUMERIC (10,0),
ORDER_TYPE_KEY NUMERIC (10,0),
STATUS_KEY NUMERIC (10,0),
PRIMARY_INSURANCE_KEY NUMERIC (10,0),
EXISTENCE NUMERIC (1,0),
DURATION NUMERIC (4,0),
NUMBER_OF_VISITS NUMERIC (3,0),
ACTIVITY_TRACER_ID NUMERIC (10,0),
AGE_KEY NUMERIC (10,0)
)
To Bulk Insert this, I've written the following...
BULK INSERT MQIC.DBO.ORDER_F
FROM 'E:MDataOrder_F.txt'
WITH
(
FORMATFILE = 'E:MDataOrder_F_format.txt'
)
and written the following format file...
9.0
17
1 SQLNUMERIC 0 10 "" 1 TRACER_ID ""
2 SQLCHAR 0 8 "" 2 DB_CREATE_DATE ""
3 SQLCHAR 0 8 "" 3 DB_UPDATED_DATE ""
4 SQLNUMERIC 0 10 "" 4 CREATE_DATE_KEY ""
5 SQLNUMERIC 0 10 "" 5 ORDER_DATE_KEY ""
6 SQLNUMERIC 0 10 "" 6 PATIENT_KEY ""
7 SQLNUMERIC 0 10 "" 7 ORDER_KEY ""
8 SQLNUMERIC 0 10 "" 8 PROVIDER_KEY ""
9 SQLNUMERIC 0 10 "" 9 LOCATION_KEY ""
10 SQLNUMERIC 0 10 "" 10 ORDER_TYPE_KEY ""
11 SQLNUMERIC 0 10 "" 11 STATUS_KEY ""
12 SQLNUMERIC 0 10 "" 12 PRIMARY_INSURANCE_KEY ""
13 SQLNUMERIC 0 1 "" 13 EXISTENCE ""
14 SQLNUMERIC 0 4 "" 14 DURATION ""
15 SQLNUMERIC 0 3 "" 15 NUMBER_OF_VISITS ""
16 SQLNUMERIC 0 10 "" 16 ACTIVITY_TRACER_ID ""
17 SQLNUMERIC 0 10 "
" 17 AGE_KEY ""
However... actually running this gives the following error...
Msg 4863, Level 16, State 4, Line 1
Bulk load data conversion error (truncation) for row 1, column 13 (EXISTENCE).
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".
Since this is my first time with this, I read the BOL items on Bulk Insert, Format Files, and each of the formatting attibutes, and made up two line "toy" examples for SQLCHAR and SQLINT, including two columns - all worked as expected.
It seemed that only SQLNUMERIC/SQLDECIMAL fell apart.
Even the following trivial example doesn't work for this field of data...
"7999163 "
CREATE TABLE MQIC.DBO.ORDER_F
(
TRACER_ID NUMERIC (10,0)
)
and
9.0
1
1 SQLNUMERIC 0 10 " " 1 TRACER_ID ""
or
9.0
1
1 SQLNUMERIC 0 10 "" 1 TRACER_ID ""
which give this error...
Msg 9803, Level 16, State 1, Line 1
Invalid data for type "numeric".
The statement has been terminated.
or
9.0
1
1 SQLNUMERIC 0 10 "/r/n" 1 TRACER_ID ""
which gives this error...
Msg 4832, Level 16, State 1, Line 1
Bulk load: An unexpected end of file was encountered in the data file.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".
Also - there was the DB_CREATE_DATE and DB_UPDATED_DATE CHAR (8) were supposed to be dates in the format of mmddyyy but clearly there is no Date datatype in SQL-Server. I would suppose these need to be converted, but am unsure how. What is clear is that the data was dumped from Oracle in text form,
Any thoughts on this would be greatly appreciated...
Thanks!
I'm trying to set up a BULK INSERT Format File for some data that I've been sent, which, according to the data documentation, comes in fixed-width format fields (no delimiters except for end-of-row 0D0A) in SQL-Server 2005 Express.
The following is the first line...
"7999163 09182003 56586 56477 3601942 1278 22139 1102 113 118 51450 1 1 63535647 10000
7999162 09182003 56586 56477 3601942 1279 22139 1102 113 118 51450 1 1 63535647 10000 "
Looking with a hex editor, all the above whitespace are 20's.
From the documentation, I've constructed the following table...
CREATE TABLE MQIC.DBO.ORDER_F
(
TRACER_ID NUMERIC (10,0),
DB_CREATE_DATE CHAR (8),
DB_UPDATED_DATE CHAR (8),
CREATE_DATE_KEY NUMERIC (10,0),
ORDER_DATE_KEY NUMERIC (10,0),
PATIENT_KEY NUMERIC (10,0),
ORDER_KEY NUMERIC (10,0),
PROVIDER_KEY NUMERIC (10,0),
LOCATION_KEY NUMERIC (10,0),
ORDER_TYPE_KEY NUMERIC (10,0),
STATUS_KEY NUMERIC (10,0),
PRIMARY_INSURANCE_KEY NUMERIC (10,0),
EXISTENCE NUMERIC (1,0),
DURATION NUMERIC (4,0),
NUMBER_OF_VISITS NUMERIC (3,0),
ACTIVITY_TRACER_ID NUMERIC (10,0),
AGE_KEY NUMERIC (10,0)
)
To Bulk Insert this, I've written the following...
BULK INSERT MQIC.DBO.ORDER_F
FROM 'E:MDataOrder_F.txt'
WITH
(
FORMATFILE = 'E:MDataOrder_F_format.txt'
)
and written the following format file...
9.0
17
1 SQLNUMERIC 0 10 "" 1 TRACER_ID ""
2 SQLCHAR 0 8 "" 2 DB_CREATE_DATE ""
3 SQLCHAR 0 8 "" 3 DB_UPDATED_DATE ""
4 SQLNUMERIC 0 10 "" 4 CREATE_DATE_KEY ""
5 SQLNUMERIC 0 10 "" 5 ORDER_DATE_KEY ""
6 SQLNUMERIC 0 10 "" 6 PATIENT_KEY ""
7 SQLNUMERIC 0 10 "" 7 ORDER_KEY ""
8 SQLNUMERIC 0 10 "" 8 PROVIDER_KEY ""
9 SQLNUMERIC 0 10 "" 9 LOCATION_KEY ""
10 SQLNUMERIC 0 10 "" 10 ORDER_TYPE_KEY ""
11 SQLNUMERIC 0 10 "" 11 STATUS_KEY ""
12 SQLNUMERIC 0 10 "" 12 PRIMARY_INSURANCE_KEY ""
13 SQLNUMERIC 0 1 "" 13 EXISTENCE ""
14 SQLNUMERIC 0 4 "" 14 DURATION ""
15 SQLNUMERIC 0 3 "" 15 NUMBER_OF_VISITS ""
16 SQLNUMERIC 0 10 "" 16 ACTIVITY_TRACER_ID ""
17 SQLNUMERIC 0 10 "
" 17 AGE_KEY ""
However... actually running this gives the following error...
Msg 4863, Level 16, State 4, Line 1
Bulk load data conversion error (truncation) for row 1, column 13 (EXISTENCE).
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".
Since this is my first time with this, I read the BOL items on Bulk Insert, Format Files, and each of the formatting attibutes, and made up two line "toy" examples for SQLCHAR and SQLINT, including two columns - all worked as expected.
It seemed that only SQLNUMERIC/SQLDECIMAL fell apart.
Even the following trivial example doesn't work for this field of data...
"7999163 "
CREATE TABLE MQIC.DBO.ORDER_F
(
TRACER_ID NUMERIC (10,0)
)
and
9.0
1
1 SQLNUMERIC 0 10 " " 1 TRACER_ID ""
or
9.0
1
1 SQLNUMERIC 0 10 "" 1 TRACER_ID ""
which give this error...
Msg 9803, Level 16, State 1, Line 1
Invalid data for type "numeric".
The statement has been terminated.
or
9.0
1
1 SQLNUMERIC 0 10 "/r/n" 1 TRACER_ID ""
which gives this error...
Msg 4832, Level 16, State 1, Line 1
Bulk load: An unexpected end of file was encountered in the data file.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".
Also - the DB_CREATE_DATE and DB_UPDATED_DATE CHAR (8) were supposed to be dates in the format of mmddyyy but clearly there is no Date datatype in SQL-Server. I would suppose these need to be converted, but am unsure how. What is clear is that the data was dumped from Oracle in text form,
Any thoughts on this would be greatly appreciated...
Thanks!
I'm trying to set up a BULK INSERT Format File for some data that I've been sent, which, according to the data documentation, comes in fixed-width format fields (no delimiters except for end-of-row 0D0A) in SQL-Server 2005 Express.
The following is the first line...
"7999163 09182003 56586 56477 3601942 1278 22139 1102 113 118 51450 1 1 63535647 10000
7999162 09182003 56586 56477 3601942 1279 22139 1102 113 118 51450 1 1 63535647 10000 "
Looking with a hex editor, all the above whitespace are 20's.
From the documentation, I've constructed the following table...
CREATE TABLE MQIC.DBO.ORDER_F
(
TRACER_ID NUMERIC (10,0),
DB_CREATE_DATE CHAR (8),
DB_UPDATED_DATE CHAR (8),
CREATE_DATE_KEY NUMERIC (10,0),
ORDER_DATE_KEY NUMERIC (10,0),
PATIENT_KEY NUMERIC (10,0),
ORDER_KEY NUMERIC (10,0),
PROVIDER_KEY NUMERIC (10,0),
LOCATION_KEY NUMERIC (10,0),
ORDER_TYPE_KEY NUMERIC (10,0),
STATUS_KEY NUMERIC (10,0),
PRIMARY_INSURANCE_KEY NUMERIC (10,0),
EXISTENCE NUMERIC (1,0),
DURATION NUMERIC (4,0),
NUMBER_OF_VISITS NUMERIC (3,0),
ACTIVITY_TRACER_ID NUMERIC (10,0),
AGE_KEY NUMERIC (10,0)
)
To Bulk Insert this, I've written the following...
BULK INSERT MQIC.DBO.ORDER_F
FROM 'E:MDataOrder_F.txt'
WITH
(
FORMATFILE = 'E:MDataOrder_F_format.txt'
)
and written the following format file...
9.0
17
1 SQLNUMERIC 0 10 "" 1 TRACER_ID ""
2 SQLCHAR 0 8 "" 2 DB_CREATE_DATE ""
3 SQLCHAR 0 8 "" 3 DB_UPDATED_DATE ""
4 SQLNUMERIC 0 10 "" 4 CREATE_DATE_KEY ""
5 SQLNUMERIC 0 10 "" 5 ORDER_DATE_KEY ""
6 SQLNUMERIC 0 10 "" 6 PATIENT_KEY ""
7 SQLNUMERIC 0 10 "" 7 ORDER_KEY ""
8 SQLNUMERIC 0 10 "" 8 PROVIDER_KEY ""
9 SQLNUMERIC 0 10 "" 9 LOCATION_KEY ""
10 SQLNUMERIC 0 10 "" 10 ORDER_TYPE_KEY ""
11 SQLNUMERIC 0 10 "" 11 STATUS_KEY ""
12 SQLNUMERIC 0 10 "" 12 PRIMARY_INSURANCE_KEY ""
13 SQLNUMERIC 0 1 "" 13 EXISTENCE ""
14 SQLNUMERIC 0 4 "" 14 DURATION ""
15 SQLNUMERIC 0 3 "" 15 NUMBER_OF_VISITS ""
16 SQLNUMERIC 0 10 "" 16 ACTIVITY_TRACER_ID ""
17 SQLNUMERIC 0 10 "
" 17 AGE_KEY ""
However... actually running this gives the following error...
Msg 4863, Level 16, State 4, Line 1
Bulk load data conversion error (truncation) for row 1, column 13 (EXISTENCE).
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".
Since this is my first time with this, I read the BOL items on Bulk Insert, Format Files, and each of the formatting attibutes, and made up two line "toy" examples for SQLCHAR and SQLINT, including two columns - all worked as expected.
It seemed that only SQLNUMERIC/SQLDECIMAL fell apart.
Even the following trivial example doesn't work for this field of data...
"7999163 "
CREATE TABLE MQIC.DBO.ORDER_F
(
TRACER_ID NUMERIC (10,0)
)
and
9.0
1
1 SQLNUMERIC 0 10 " " 1 TRACER_ID ""
or
9.0
1
1 SQLNUMERIC 0 10 "" 1 TRACER_ID ""
which give this error...
Msg 9803, Level 16, State 1, Line 1
Invalid data for type "numeric".
The statement has been terminated.
or
9.0
1
1 SQLNUMERIC 0 10 "/r/n" 1 TRACER_ID ""
which gives this error...
Msg 4832, Level 16, State 1, Line 1
Bulk load: An unexpected end of file was encountered in the data file.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".
Also - the DB_CREATE_DATE and DB_UPDATED_DATE CHAR (8) were supposed to be dates in the format of mmddyyy but clearly there is no Date datatype in SQL-Server. I would suppose these need to be converted, but am unsure how. What is clear is that the data was dumped from Oracle in text form,
Any thoughts on this would be greatly appreciated...
Thanks!
Is there a way to clear or ignore errors so that a script file will continue to run in 2000 T-SQL?
I.E. something like this but compatible with 2000:
BEGIN TRY
ALTER TABLE dbo.SomeTable
DROP CONSTRAINT FK_SomeTable_ID
END TRY
BEGIN CATCH
--ignore, do nothing
END CATCH
--continue doing other things
I would like to allow the users to clear the paramaters in a report and start a new query. I tried creating an image and setting the navigation to jump to the same report. This clears the parameters because of the postback but the parameter area collapses. Is there another way to do this or force the parameter area to stay expanded?
View 1 Replies View RelatedIf i have been using sql server 2005 express for developing my application and i decide to upgrade to sql server 2005 express with advanced services while still working on the same application, what will happen to my application's database. Can i be able to continue with my work with out any major regrets.
View 1 Replies View Related
Hi,
I'm trying to learn some VB programming with the VB 2005 Express Absolute Beginner Series video tutorials (which I think is great) and have come across a problem that I can't solve.
When I follow the instructions in Lesson 9 (Databinding Data to User Interface Controls) my application will display the data from the database correctly and I can edit it (and as long as the debugger is running the data remains changed). However, the changes won't propagate back to the database. I don't get any error messages but after I edit the data, save (with the save button on the BindingNavigator toolbar), and end debugging the data in my database remains unchanged. When I use a MessageBox to show how many rows where edited/updated in the
Me.myTableTableAdapter.Update(Me.myDatabaseDataSet.myTable)
I get the correct number back. I'm sure the problem is not due to coding errors since I've also tried running the accompanying Lesson 9 project file that can be downloaded from MSDN and the problem persists.
I'm using Windows XP SP2, SQL Server 2005 Express Edition and VB 2005 Express Edition. I've tried installing SQL Server 2005 Express with a number of different settings, including default settings, but it doesn't make any difference.
Would greatly appreciate any feedback on this as I'm keen to resolve this problem so I can get on with the next tutorial lesson.
Thanks,
Ieyasu
HiIm trying to connect Visual Basic Express 2005 to a remote SQL Server Express 2005. I cant find how i can do that in VB.net Express.In Web developer there are no problem to connect to a remote SQL server but i cant find it in VB.net Express. The XP with the SQL server that i want to connect to is on the local network. Greatful for help!
View 1 Replies View RelatedHi Guys,
I created a Product database table using Visual Basic 2005 Express and SQL Server 2005 Express. I have just added a new column [Picture] to the database table, which of course, should store an image or picture of a product. I am writing to kindly ask you guys for help .
i) How do I include image files into this column [Picture]?
ii) How do I get this image to display on Visual Basic 2005 Express form, so that when a product is selected the product image is displayed accordingly?
Your help much appreciated. Thanks.
Paul
Hi,
I want to make a component library in Visual Basic.NET and connect to a remote Sql Server. When I create a new DataSet with the wizard, I can only connect to a .mdf file, but not to a Sql Server. With Visual Web Developer I can connect to a Sql server. What is the difference between these enviroments ? How can I do the same with Visual Basic.NET ?
Thanks in advance.
Currently I have following things installed on my Computer
1. SQL Server Express 2005
2. SQL Server Management Studio Express 2005 CTP
I need to install following things
A. Microsoft SQL Server 2005 Express Edition with Advanced Services
B. Microsoft SQL Server 2005 Express Edition Toolkit
Do I need to uninstall any any of 1 or 2?
What should be my path to upgrade these software.
I am having a hard time finding the executable file to start sql express 2005 or SQL exress 2005 with advance services. I installed the SQL express and had the desktop icon....but I thought i would need to uninstall it before installing SQL 2005 with advance services. Now I can not find anything to start the program.
Hi all,
I have a database name MyDatabase (SQL Server Express Dabase File). Is there anyway that I could convert it to SQL Server Compact Edition File?
By the way does anyone here got any problem with programming in SQL Server Compact Edition? It troubles me.
Thanks,
bombie
HI
Q1: Does Sql Server 2005 Express support Web/Internet to other SQL Server 2005 Express Clients or does it have to Synch across the internet to a fully installed setup SQL Server 2005 with IIS?
Q2: Does SQL Server 2005 Express support Direct Replication between other SQL Server 2005 Express clients?
Regards
Hi all,
I have installed SQL server 2005 express edition with SQL server Management studio express (SSMSE).
I have installed also SQLce and I would know how I can manage sql compact edition databases (.ldf) with sql SSMSE, if it is possible!
I would be grateful if you could explain it trought a detailed guide (I am a beginner user of sql server tools) or trought a link to useful sites.
I'm Looking forward for your reply and still trying...
Alessandro
I'm a little stuck here. How can I import a flat tab delimited file into a SQL 2005 Express table? The standard DTS and import features are not there :-(Thanks,Casey
View 1 Replies View RelatedHi there,
I am just starting to learn SQL 2005 Express. After opening the Management Studio Express, I right Click on the Databases node and create new database. then create a name etc. The problem is that when I click ok to create the new database, I get a warning saying that Input a filename. However when I click on filename (after filepath) it is greyed out and I cant add a filename.
Does anyone know how to remedy this?
Regards
DML