How To Control Error Log File In SQL Server 2005 Express?

Dec 30, 2007

I 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.


View 5 Replies


ADVERTISEMENT

SQL Server 2005 (express) Setup Error 1603 - Log File Below

Aug 16, 2006

=== 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:

View 1 Replies View Related

Error While Storing A Zip File With Size More Than 1MB In MS SQL Server 2005 Express

Aug 9, 2007

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...

View 5 Replies View Related

How To Control SQL Server 2005 Express Installed As A Prerequisite

Jul 4, 2006

Suppose I check "SQL Server 2005 Express Edition" as one of the prerequisites for a custom app in a Windows Setup project.

From reading whatever docs I could get my hands on, it's still not clear to me how to control the installation of SQL Server Express with respect to things like instance name, service account, etc, etc.

In other words, this is stuff that's normally the domain of template.ini. However, there's no clear indication of where I should put template.ini so that the install of "prerequisite" SQL Server Express will see it and configure accordingly...

Thanks in advance to anyone who can help solve this...

Josh

View 3 Replies View Related

SSIS Doesn`t Start After Applying SQL Server 2005 SP1 Error Message 7000 Service Control Manager

Apr 27, 2006

SSIS doesn`t start after applying SQL Server 2005 SP1



I get an error Message in event log

event id 7000 source: Service Control Manager Type: Error

Message:

The SQL Server Integration Services service failed to start due to the following error:

The service did not respond to the start or control request in a timely fashion.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.



regards

Lothar Belle

View 4 Replies View Related

Error While Trying To Install SQL Server Express 2005 Express Edition

Mar 8, 2008

Hi,

I'm getting an error while trying to install SQL Server Express 2005 Express Edition. I'm attaching the log of the installation process here. Please throw some light on the same.


Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (3) The system cannot find the path specified.

.

<Func Name='GetCAContext'>

<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>

Doing Action: Do_sqlShutDownRANUInstance

PerfTime Start: Do_sqlShutDownRANUInstance : Sat Mar 08 21:39:12 2008

<Func Name='Do_sqlShutDownRANUInstance'>

Service SQLEXPRESS with parameters '' is being started at Sat Mar 08 21:39:12 2008

Unable to start service (3)

Error Code: 0x80070003 (3)
Windows Error Text: The system cannot find the path specified.

Source File Name: sqlsetuplibservice.cpp
Compiler Timestamp: Wed Jun 14 16:29:04 2006
Function Name: sqls:ervice:tart
Source Line Number: 316





---- Context -----------------------------------------------




Setting status of unmanaged components and removing unmanaged resources





Error Code: 3

MSI (s) (D0!64) [21:39:17:257]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (3) The system cannot find the path specified.

.



Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (3) The system cannot find the path specified.

.

View 4 Replies View Related

Restoring BAK File Sql Server 2005 Express

Apr 3, 2007

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

View 4 Replies View Related

How To Run A .sql File In SQL Server 2005 Express Edition.

Aug 9, 2007

 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.

View 2 Replies View Related

How To Clear Log File In SQL SERVER 2005 EXpress SP2

Dec 25, 2007

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

View 3 Replies View Related

Error SQL Server 2005 Express Error: 70347(0x112cb) WMI

Mar 28, 2007

Que tal. Al iniciar el instalador SQL Server 2005 Express me saca el error "System Configuration Checker cannot be executed due to WMI configuration on te machine..." Si alguien sabe como solucionarlo agradeceria se ayuda. Gracias.

View 1 Replies View Related

How Many Open Connections Does SQL Server 2005 Express Allow To .mdf File

May 17, 2007

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.

View 2 Replies View Related

Connect To MDF File Without Having SQL Server 2005 Express Installed

Jun 21, 2007

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
 

View 1 Replies View Related

Import Flat File Into SQL Server 2005 Express

Jan 6, 2007

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 Related

Problems Connecting To Sql Express 2005 Server, Where Mdf File Go?

Jul 10, 2006

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!?

View 1 Replies View Related

How Can I Clear Log File In MS SQL SERVER 2005 Express Edition SP2

Dec 27, 2007

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 .

View 9 Replies View Related

WMI File Watcher In Control Flow Issues Quota Violation Error

May 22, 2008

My SSIS control flow includes a standard "textbook" WMI Event Watcher Task that monitors a folder for incoming files. Generally it works fine, but now I regularly see the error message:

"Watching for the Wql Query caused the following system exception: "Quota Violation." Check the query for errors or WMI connection for access rights/permissions"


I do not see any indication of trouble in the event logs. The SSIS log simply states that it failed.

Is there any magic about WMI Event Watcher?

When I restart, it runs fine for hours.

SQL05 is 9.0.3054 on W2003 with all microsoft updates applied. It is basically a bare machine with SQL Server, SSIS running and a service that kicks in occasionally.

Thanks for reading!

View 3 Replies View Related

How To Transfer Or Export Dbf File To SQL Server 2005 Express Edition?

Dec 20, 2006

I 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

View 1 Replies View Related

Populating A Table In SQL Server 2005 Express From A Text File (*.txt)

Apr 10, 2008

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

View 10 Replies View Related

Can I Create Database Using Backup File In SQl Server 2005 Express Edition

Jul 21, 2007

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

View 2 Replies View Related

SQL Server Express For Login Control

Aug 11, 2006

I have built a page with the login control using the default sql server express database that is integrated into the application. I have got it working on my development machine and want to post it on the web with a web hosting company. I did not know if they had to have sql server express installed on that machine for my database to work properly or will it work with sql server 2005 installed. Most web hosting companies that I have called say they only support sql server 2005 and not sql server express. I was unsure if the login would work or not. Please help with this issue. I am new at ASP.net and really enjoy it. However, I want to ensure that my site will work on the web as it does on my machine.

View 4 Replies View Related

How To Apply SQL Server 2005 Express SP1 To The Version Of SQL Server 2005 Express Which Installs With Visual Studio 2005?

Aug 8, 2006

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

View 11 Replies View Related

SQL Server 2005 Express Error

Dec 6, 2006

Hi, I need to reinstall my version of SQL Server 2005 Express. on the on the install I get the following message

A network error occurred while attempting to read from the file D:61491.msi

I cannot find this file.

I have also tried to remove from add/remove programs and get: error 2356

I have also tried removing using the Windows removal tool.

Any help would be a great help.



AC

View 1 Replies View Related

SQL Server 2005 Express Error

Apr 16, 2006

i've installed the SQL Server 2005 Express and something is wrong...that icon that represents that the instance is running isn't showed...when i try to add a data source using the IDE on VB Express, this error apear:

"Failed to generate a user instance of SQL Server. Only an integrated connection can generate a user interface. The connection will be closed"

i installed the SQL Server Management Studio too...and it's working....but i can't use!!!

could somebody help me?!

tks...

View 1 Replies View Related

Error During SQL Server 2005 Express Help...

Feb 16, 2007

The "Setup Progress" window displays the selected components to be configured.

After completion, the window displays a red x beside Reporting Services.

On all the other results, you can click and view a log generated during installation.

Clicking on the "Reporting Services" (that didn't install) does not display the log file.

Any help is appreciated.

Thanks,

Trint

View 1 Replies View Related

BULK INSERT Format File Problems With SQLNUMERICAL In SQL-Server 2005 Express

May 24, 2006

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!

View 1 Replies View Related

BULK INSERT Format File Problems With SQLNUMERICAL In SQL-Server 2005 Express

May 24, 2006

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!

View 1 Replies View Related

BULK INSERT Format File Problems With SQLNUMERICAL In SQL-Server 2005 Express

May 24, 2006

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!

View 5 Replies View Related

Source Code Control And SQL Server Express??

Apr 18, 2006

Hi,

I was wondering if anybody could advise on source code control for SQL Server express, for the table schema and stored procedures?

I currently use Sourcesafe V6 to work with visual studio 6 and 2003 (although it isn't integrated in 2003), and wondered if that can be used?

Any suggestions would be greatly appreciated, as I see this as a disaster waiting to happen!

Thanks in advance.

Mark

View 4 Replies View Related

MS Sql Server 2005 Express Edition Error

Apr 27, 2005

When i install the s1l express 2005 the following error occur. Anyone can help
[ 0 4 / 2 7 / 0 5 , 1 9 : 2 4 : 2 6 ]   V S   S c e n a r i o :   [ 2 ]   F a i l e d   t o   p a s s   t h e   W a r n i n g s / B l o c k s   c h e c k s   i n   C V S S c e n a r i o : : S t a r t ( )   [ 0 4 / 2 7 / 0 5 , 1 9 : 3 7 : 5 5 ]   M i c r o s o f t   V i s u a l   S t u d i o   2 0 0 5   S t a n d a r d   E d i t i o n   B e t a   2   -   E N U :   [ 2 ]   E R R O R : E r r o r   1 3 3 1 . F a i l e d   t o   c o r r e c t l y   c o p y   v c r e d i s t _ I A 6 4 . e x e   f i l e :   C R C   e r r o r .   [ 0 4 / 2 7 / 0 5 , 1 9 : 3 7 : 5 6 ]   M i c r o s o f t   V i s u a l   S t u d i o   2 0 0 5   S t a n d a r d   E d i t i o n   B e t a   2   -   E N U :   [ 2 ]   E R R O R : E r r o r   1 3 3 1 . F a i l e d   t o   c o r r e c t l y   c o p y   v c r e d i s t _ x 6 4 . e x e   f i l e :   C R C   e r r o r .   [ 0 4 / 2 7 / 0 5 , 1 9 : 4 8 : 1 9 ]   M i c r o s o f t   S Q L   S e r v e r   2 0 0 5   E x p r e s s   E d i t i o n   A p r i l   C T P :   [ 2 ]   E r r o r   c o d e   1 6 0 3   f o r   t h i s   c o m p o n e n t   m e a n s   " F a t a l   e r r o r   d u r i n g   i n s t a l l a t i o n .   "   [ 0 4 / 2 7 / 0 5 , 1 9 : 4 8 : 2 0 ]   M i c r o s o f t   S Q L   S e r v e r   2 0 0 5   E x p r e s s   E d i t i o n   A p r i l   C T P :   [ 2 ]   S e t u p   F a i l e d   o n   c o m p o n e n t   M i c r o s o f t   S Q L   S e r v e r   2 0 0 5   E x p r e s s   E d i t i o n   A p r i l   C T P   * * * E n d O f S e s s i o n * * * [ 0 4 / 2 7 / 0 5 , 1 9 : 2 4 : 2 6 ]   V S   S c e n a r i o :   [ 2 ]   F a i l e d   t o   p a s s   t h e   W a r n i n g s / B l o c k s   c h e c k s   i n   C V S S c e n a r i o : : S t a r t ( )   [ 0 4 / 2 7 / 0 5 , 1 9 : 3 7 : 5 5 ]   M i c r o s o f t   V i s u a l   S t u d i o   2 0 0 5   S t a n d a r d   E d i t i o n   B e t a   2   -   E N U :   [ 2 ]   E R R O R : E r r o r   1 3 3 1 . F a i l e d   t o   c o r r e c t l y   c o p y   v c r e d i s t _ I A 6 4 . e x e   f i l e :   C R C   e r r o r .   [ 0 4 / 2 7 / 0 5 , 1 9 : 3 7 : 5 6 ]   M i c r o s o f t   V i s u a l   S t u d i o   2 0 0 5   S t a n d a r d   E d i t i o n   B e t a   2   -   E N U :   [ 2 ]   E R R O R : E r r o r   1 3 3 1 . F a i l e d   t o   c o r r e c t l y   c o p y   v c r e d i s t _ x 6 4 . e x e   f i l e :   C R C   e r r o r .   [ 0 4 / 2 7 / 0 5 , 1 9 : 4 8 : 1 9 ]   M i c r o s o f t   S Q L   S e r v e r   2 0 0 5   E x p r e s s   E d i t i o n   A p r i l   C T P :   [ 2 ]   E r r o r   c o d e   1 6 0 3   f o r   t h i s   c o m p o n e n t   m e a n s   " F a t a l   e r r o r   d u r i n g   i n s t a l l a t i o n .   "   [ 0 4 / 2 7 / 0 5 , 1 9 : 4 8 : 2 0 ]   M i c r o s o f t   S Q L   S e r v e r   2 0 0 5   E x p r e s s   E d i t i o n   A p r i l   C T P :   [ 2 ]   S e t u p   F a i l e d   o n   c o m p o n e n t   M i c r o s o f t   S Q L   S e r v e r   2 0 0 5   E x p r e s s   E d i t i o n   A p r i l   C T P   [ 0 4 / 2 7 / 0 5 , 1 9 : 5 1 : 3 4 ]   V S 7 0 p g u i :   [ 2 ]   D e p C h e c k   i n d i c a t e s   M i c r o s o f t   S Q L   S e r v e r   2 0 0 5   E x p r e s s   E d i t i o n   A p r i l   C T P   i s   n o t   i n s t a l l e d .   [ 0 4 / 2 7 / 0 5 , 2 0 : 2 4 : 1 9 ]   M i c r o s o f t   S Q L   S e r v e r   2 0 0 5   E x p r e s s   E d i t i o n   A p r i l   C T P :   [ 2 ]   E r r o r   c o d e   1 6 0 3   f o r   t h i s   c o m p o n e n t   m e a n s   " F a t a l   e r r o r   d u r i n g   i n s t a l l a t i o n .   "   [ 0 4 / 2 7 / 0 5 , 2 0 : 2 4 : 1 9 ]   M i c r o s o f t   S Q L   S e r v e r   2 0 0 5   E x p r e s s   E d i t i o n   A p r i l   C T P :   [ 2 ]   S e t u p   F a i l e d   o n   c o m p o n e n t   M i c r o s o f t   S Q L   S e r v e r   2 0 0 5   E x p r e s s   E d i t i o n   A p r i l   C T P   * * * E n d O f S e s s i o n * * *

View 5 Replies View Related

Error Setting Up SQL Server Express 2005

Nov 29, 2005

Hi,I had the SQL Server Express installed on my desktop and it was working just fine. Now, I upgraded to .Net 2.0 and I had some problems with the SQL Server Express just like in post http://forums.asp.net/1070169/ShowPost.aspx.These problems were solved by using a cleanup tool but now when i try so setup the SQL Server Express 2005 i get the error:SQL Server Component Update will install the following components for SQL Server Setup:- (ok) Microsoft SQL Native Client- (error) Microsoft SQL Server 2005 Setup Support FilesErrors occurred during the installation:Error 1603 installing Microsoft SQL Server 2005 Setup Support Files.See log file for more detailed information.Fatal error during installation.The log file as lots of information such as:Product         : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install         : Failed Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0010_WS10170_Support.log Last Action     : InstallFinalize Error String    : The installer has encountered an unexpected error. The error code is 2908. Could not register component {1F3316BE-825B-4390-A9D2-AF3EECCAE9F6}. Error Number    : 2908 -------------------------------------------------------------------------------- WS10170 : There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information. Can someone please help me on trying to avoid format the desktop.Thanks,Stromberg

View 2 Replies View Related

Error Connecting To Sql Server 2005 Express

Feb 15, 2006

Just manged to install sql server 2005 express after two days.  I have a problem now!  When i try to connect to it via my browser (local database), i get the following error:
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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
I have opened the surface area configuration manager and set the connections to remote and local but it still doesnt work
 
Any ideas would be great
Paul

View 2 Replies View Related

SQL Server Express 2005 Datename Error?

Oct 11, 2007

I was trying to return the month name in a query but didn't get the results that I expected. To demonstrate, I wrote this query:


SELECT GETDATE(), DATENAME(DAY,DAY(GETDATE()))

SELECT GETDATE(), DATENAME(MONTH, MONTH(GETDATE()))


and got this result:


----------------------- ------------------------------

2007-10-11 14:54:29.147 12

(1 row(s) affected)



----------------------- ------------------------------

2007-10-11 14:54:29.147 January

(1 row(s) affected)


Am I doing something wrong or is SQL Server doing something odd? I need to find a fix for this pretty quickly and any help would be greatly appreciated.

Thanks!

View 8 Replies View Related

Error Installing SQL Server Express 2005

Dec 19, 2007

I've been trying to install SQL Server Express 2005 on my machine at home (XP Pro). However, when I get done, I get the following error when I restart my computer (at the login screen): "Your SQL Server installation is either corrupt or has been tampered with (Error getting instance ID from name.). Please uninstall the re-run setup to correct this problem."

I have uninstalled and reinstalled a number of times, with always thesame result. I had Visual Studio Orcas Beta 2 installed, so I thought that might have had something to do with it. I uninstalled everything development related on the machine (including all versions of the .NET Framework), and am still getting the same error. I tried installing along with Visual Studio 2005 (since it can be installed through the VS installer), same error.

I haven't been able to find any helpful information on this error. It seems everyone else is seeing it when they try to open Management Studio or some other program, but I am seeing it on system start.

Anyone have any thoughts? I'd really like to get this working.
Thanks.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved