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...
I installed sql 2005 a while back. Then I recently found out my file system was fat32 (I don't understand why the hardware people did this...) and I had to convert to NTFS. Naturally the sql service no longer worked so I uninstalled inorder to reinstall now I can't reinstall it I keep getting this message
native_error=5039, msg=[Microsoft][SQL Native Client][SQL Server]MODIFY FILE failed. Specified size is less than current size.
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 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.
Does anyone know whats wrong with my code? ~Nothing wrong with my code, code is correct!
I let it run and it keeps saying that the file does not exist. Seem as though, the path of my file doesn't exist! Any suggestions on how to program the path of my file so I can be able to retreive it such as open the file and access the file?
Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim SQL As String
Dim rawData() As Byte
Dim RowsAffected As Integer
Dim filename As String
filename = "H:My Documentsabc.pdf"
Try
If System.IO.File.Exists(filename) Then
Dim filePermission As New System.Security.Permissions.FileIOPermission(System.Security.Permissions.FileIOPermissionAccess.Read, System.Security.AccessControl.AccessControlActions.View, filename)
filePermission.Demand()
Else
MessageBox.Show("file does not exist", "File", MessageBoxButtons.OK, MessageBoxIcon.Information)
End If
Dim fs As FileStream
fs = New FileStream(filename, FileMode.Open, FileAccess.Read)
I am trying to resize a database initial log file from 500M to 2M. I€™m using€?
ALTER DATABASE <DBNAME> MODIFY FILE ( NAME = <DBLOGFILENAME, SIZE = 2 ) "
And I'm getting "MODIFY FILE failed. Specified size is less than current size." I tried going into the database properties and setting the log file to 2M, but it doesn€™t keep the changes.
=== Verbose logging started: 8/16/2006 8:56:23 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: c:faca48e439bf4182f2bd96setup.exe === MSI (c) (98:00) [08:56:23:850]: Resetting cached policy values MSI (c) (98:00) [08:56:23:850]: Machine policy value 'Debug' is 0 MSI (c) (98:00) [08:56:23:850]: ******* RunEngine: ******* Product: c:faca48e439bf4182f2bd96SetupSqlSupport.msi ******* Action: ******* CommandLine: ********** MSI (c) (98:00) [08:56:23:850]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (98:00) [08:56:23:850]: Grabbed execution mutex. MSI (c) (98:00) [08:56:23:850]: Cloaking enabled. MSI (c) (98:00) [08:56:23:850]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (98:00) [08:56:23:860]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (70:58) [08:56:23:870]: Grabbed execution mutex. MSI (s) (70:FC) [08:56:23:870]: Resetting cached policy values MSI (s) (70:FC) [08:56:23:870]: Machine policy value 'Debug' is 0 MSI (s) (70:FC) [08:56:23:870]: ******* RunEngine: ******* Product: c:faca48e439bf4182f2bd96SetupSqlSupport.msi ******* Action: ******* CommandLine: ********** MSI (s) (70:FC) [08:56:23:870]: Machine policy value 'DisableUserInstalls' is 0 MSI (s) (70:FC) [08:56:23:870]: File will have security applied from OpCode. MSI (s) (70:FC) [08:56:23:920]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'c:faca48e439bf4182f2bd96SetupSqlSupport.msi' against software restriction policy MSI (s) (70:FC) [08:56:23:920]: SOFTWARE RESTRICTION POLICY: c:faca48e439bf4182f2bd96SetupSqlSupport.msi has a digital signature MSI (s) (70:FC) [08:56:23:990]: SOFTWARE RESTRICTION POLICY: c:faca48e439bf4182f2bd96SetupSqlSupport.msi is permitted to run at the 'unrestricted' authorization level. MSI (s) (70:FC) [08:56:23:990]: End dialog not enabled MSI (s) (70:FC) [08:56:23:990]: Original package ==> c:faca48e439bf4182f2bd96SetupSqlSupport.msi MSI (s) (70:FC) [08:56:23:990]: Package we're running from ==> c:WINDOWSInstaller4e59e6d.msi MSI (s) (70:FC) [08:56:23:990]: APPCOMPAT: looking for appcompat database entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'. MSI (s) (70:FC) [08:56:23:990]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (70:FC) [08:56:23:990]: MSCOREE already loaded, using loaded copy MSI (s) (70:FC) [08:56:24:000]: Machine policy value 'TransformsSecure' is 0 MSI (s) (70:FC) [08:56:24:000]: User policy value 'TransformsAtSource' is 0 MSI (s) (70:FC) [08:56:24:000]: Machine policy value 'DisablePatch' is 0 MSI (s) (70:FC) [08:56:24:000]: Machine policy value 'AllowLockdownPatch' is 0 MSI (s) (70:FC) [08:56:24:000]: Machine policy value 'DisableLUAPatching' is 0 MSI (s) (70:FC) [08:56:24:000]: Machine policy value 'DisableFlyWeightPatching' is 0 MSI (s) (70:FC) [08:56:24:000]: APPCOMPAT: looking for appcompat database entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'. MSI (s) (70:FC) [08:56:24:000]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (70:FC) [08:56:24:000]: Transforms are not secure. MSI (s) (70:FC) [08:56:24:000]: Note: 1: 2205 2: 3: Control MSI (s) (70:FC) [08:56:24:000]: Command Line: ADDLOCAL=All REINSTALLMODE=vomus REBOOT=ReallySuppress CURRENTDIRECTORY=c:faca48e439bf4182f2bd96 CLIENTUILEVEL=3 CLIENTPROCESSID=2712 MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{EE7DF8EF-0E50-44E1-9603-0E4FD66A993D}'. MSI (s) (70:FC) [08:56:24:000]: Product Code passed to Engine.Initialize: '' MSI (s) (70:FC) [08:56:24:000]: Product Code from property table before transforms: '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}' MSI (s) (70:FC) [08:56:24:000]: Product Code from property table after transforms: '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}' MSI (s) (70:FC) [08:56:24:000]: Product not registered: beginning first-time install MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding ProductState property. Its value is '-1'. MSI (s) (70:FC) [08:56:24:000]: Entering CMsiConfigurationManager::SetLastUsedSource. MSI (s) (70:FC) [08:56:24:000]: User policy value 'SearchOrder' is 'nmu' MSI (s) (70:FC) [08:56:24:000]: Adding new sources is allowed. MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding PackagecodeChanging property. Its value is '1'. MSI (s) (70:FC) [08:56:24:000]: Package name extracted from package path: 'SqlSupport.msi' MSI (s) (70:FC) [08:56:24:000]: Package to be registered: 'sqlsupport.msi' MSI (s) (70:FC) [08:56:24:000]: Note: 1: 2262 2: AdminProperties 3: -2147287038 MSI (s) (70:FC) [08:56:24:000]: Machine policy value 'DisableMsi' is 0 MSI (s) (70:FC) [08:56:24:000]: Machine policy value 'AlwaysInstallElevated' is 0 MSI (s) (70:FC) [08:56:24:000]: User policy value 'AlwaysInstallElevated' is 0 MSI (s) (70:FC) [08:56:24:000]: Product installation will be elevated because user is admin and product is being installed per-machine. MSI (s) (70:FC) [08:56:24:000]: Running product '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}' with elevated privileges: Product is assigned. MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'All'. MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding REINSTALLMODE property. Its value is 'vomus'. MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding REBOOT property. Its value is 'ReallySuppress'. MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding CURRENTDIRECTORY property. Its value is 'c:faca48e439bf4182f2bd96'. MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding CLIENTUILEVEL property. Its value is '3'. MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding CLIENTPROCESSID property. Its value is '2712'. MSI (s) (70:FC) [08:56:24:000]: TRANSFORMS property is now: MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding VersionDatabase property. Its value is '200'. MSI (s) (70:FC) [08:56:24:000]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHApplication Data MSI (s) (70:FC) [08:56:24:000]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHFavorites MSI (s) (70:FC) [08:56:24:000]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHNetHood MSI (s) (70:FC) [08:56:24:010]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHMy Documents MSI (s) (70:FC) [08:56:24:010]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHPrintHood MSI (s) (70:FC) [08:56:24:010]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHRecent MSI (s) (70:FC) [08:56:24:010]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHSendTo MSI (s) (70:FC) [08:56:24:010]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHTemplates MSI (s) (70:FC) [08:56:24:010]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersApplication Data MSI (s) (70:FC) [08:56:24:010]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHLocal SettingsApplication Data MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHMy DocumentsMy Pictures MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsAdministrative Tools MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsStartup MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuPrograms MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart Menu MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersDesktop MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHStart MenuProgramsAdministrative Tools MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHStart MenuProgramsStartup MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHStart MenuPrograms MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHStart Menu MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHDesktop MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersTemplates MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:WINDOWSFonts MSI (s) (70:FC) [08:56:24:020]: Note: 1: 2898 2: MS Sans Serif 3: MS Sans Serif 4: 0 5: 16 MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding Privileged property. Its value is '1'. MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding USERNAME property. Its value is ' '. MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding COMPANYNAME property. Its value is ' '. MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding DATABASE property. Its value is 'c:WINDOWSInstaller4e59e6d.msi'. MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding OriginalDatabase property. Its value is 'c:faca48e439bf4182f2bd96SetupSqlSupport.msi'. MSI (s) (70:FC) [08:56:24:030]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (70:FC) [08:56:24:030]: Machine policy value 'DisableRollback' is 0 MSI (s) (70:FC) [08:56:24:030]: User policy value 'DisableRollback' is 0 MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding UILevel property. Its value is '2'. === Logging started: 8/16/2006 8:56:24 === MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding Preselected property. Its value is '1'. MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding ACTION property. Its value is 'INSTALL'. MSI (s) (70:FC) [08:56:24:030]: Doing action: INSTALL MSI (s) (70:FC) [08:56:24:030]: Running ExecuteSequence MSI (s) (70:FC) [08:56:24:030]: Doing action: CommonFilesFolder.DCA909F7_1890_4AD6_9EAE_3C9D956FE00B Action start 8:56:24: INSTALL. MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding CommonFilesFolder.DCA909F7_1890_4AD6_9EAE_3C9D956FE00B property. Its value is 'C:Program FilesCommon Files'. Action start 8:56:24: CommonFilesFolder.DCA909F7_1890_4AD6_9EAE_3C9D956FE00B. MSI (s) (70:FC) [08:56:24:030]: Doing action: LocalAppDataFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 Action ended 8:56:24: CommonFilesFolder.DCA909F7_1890_4AD6_9EAE_3C9D956FE00B. Return value 1. MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding LocalAppDataFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'C:Documents and SettingsRickHLocal SettingsApplication Data'. Action start 8:56:24: LocalAppDataFolder.D0DF3458_A845_11D3_8D0A_0050046416B9. MSI (s) (70:FC) [08:56:24:030]: Doing action: WindowsFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 Action ended 8:56:24: LocalAppDataFolder.D0DF3458_A845_11D3_8D0A_0050046416B9. Return value 1. MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding WindowsFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'C:WINDOWS'. Action start 8:56:24: WindowsFolder.D0DF3458_A845_11D3_8D0A_0050046416B9. MSI (s) (70:FC) [08:56:24:030]: Doing action: ProgramFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 Action ended 8:56:24: WindowsFolder.D0DF3458_A845_11D3_8D0A_0050046416B9. Return value 1. MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding ProgramFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'C:Program Files'. Action start 8:56:24: ProgramFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9. MSI (s) (70:FC) [08:56:24:030]: Doing action: CommonFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 Action ended 8:56:24: ProgramFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9. Return value 1. MSI (s) (70:FC) [08:56:24:040]: PROPERTY CHANGE: Adding CommonFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'C:Program FilesCommon Files'. Action start 8:56:24: CommonFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9. MSI (s) (70:FC) [08:56:24:040]: Doing action: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E Action ended 8:56:24: CommonFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9. Return value 1. MSI (s) (70:FC) [08:56:24:040]: PROPERTY CHANGE: Adding WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'. Action start 8:56:24: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. MSI (s) (70:FC) [08:56:24:040]: Doing action: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E Action ended 8:56:24: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (70:FC) [08:56:24:040]: PROPERTY CHANGE: Adding SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'. Action start 8:56:24: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. MSI (s) (70:FC) [08:56:24:040]: Doing action: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E Action ended 8:56:24: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (70:FC) [08:56:24:040]: PROPERTY CHANGE: Adding WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'. Action start 8:56:24: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. MSI (s) (70:FC) [08:56:24:040]: Doing action: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E Action ended 8:56:24: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (70:FC) [08:56:24:040]: PROPERTY CHANGE: Adding SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'. Action start 8:56:24: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. MSI (s) (70:FC) [08:56:24:040]: Doing action: LaunchConditions Action ended 8:56:24: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (70:FC) [08:56:24:040]: Note: 1: 2205 2: 3: LaunchCondition MSI (s) (70:FC) [08:56:24:040]: Note: 1: 2228 2: 3: LaunchCondition 4: SELECT `Condition`, `Description` FROM `LaunchCondition` Action start 8:56:24: LaunchConditions. MSI (s) (70:FC) [08:56:24:040]: Doing action: FindRelatedProducts Action ended 8:56:24: LaunchConditions. Return value 0. MSI (s) (70:FC) [08:56:24:040]: Note: 1: 2205 2: 3: Upgrade MSI (s) (70:FC) [08:56:24:040]: Note: 1: 2228 2: 3: Upgrade 4: SELECT `UpgradeCode`,`VersionMin`,`VersionMax`,`Language`,`Attributes`,`ActionProperty` FROM `Upgrade` Action start 8:56:24: FindRelatedProducts. MSI (s) (70:FC) [08:56:24:040]: Skipping action: Sqlmsirc_ValidateAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false) MSI (s) (70:FC) [08:56:24:040]: Skipping action: Sqlmsirc_RefCountAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false) MSI (s) (70:FC) [08:56:24:040]: Skipping action: Sqlmsirc_BackupAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false) MSI (s) (70:FC) [08:56:24:040]: Skipping action: Sqlmsirc_RegisterAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false) MSI (s) (70:FC) [08:56:24:040]: Skipping action: Sqlmsirc_RestoreAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false) MSI (s) (70:FC) [08:56:24:040]: Doing action: AppSearch Action ended 8:56:24: FindRelatedProducts. Return value 0. MSI (s) (70:FC) [08:56:24:050]: Note: 1: 2205 2: 3: AppSearch MSI (s) (70:FC) [08:56:24:050]: Note: 1: 2228 2: 3: AppSearch 4: SELECT `Property`, `Signature_` FROM `AppSearch` Action start 8:56:24: AppSearch. MSI (s) (70:FC) [08:56:24:050]: Doing action: CCPSearch Action ended 8:56:24: AppSearch. Return value 0. MSI (s) (70:FC) [08:56:24:050]: Note: 1: 2205 2: 3: CCPSearch MSI (s) (70:FC) [08:56:24:050]: Note: 1: 2228 2: 3: CCPSearch 4: SELECT `Signature_` FROM `CCPSearch` Action start 8:56:24: CCPSearch. MSI (s) (70:FC) [08:56:24:050]: Doing action: RMCCPSearch Action ended 8:56:24: CCPSearch. Return value 0. MSI (s) (70:FC) [08:56:24:050]: Note: 1: 2205 2: 3: CCPSearch MSI (s) (70:FC) [08:56:24:050]: Note: 1: 2228 2: 3: CCPSearch 4: SELECT `Signature_` FROM `CCPSearch` Action start 8:56:24: RMCCPSearch. MSI (s) (70:FC) [08:56:24:050]: Skipping action: Sqlmsirc_CheckLanguage.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false) MSI (s) (70:FC) [08:56:24:050]: Doing action: CostInitialize Action ended 8:56:24: RMCCPSearch. Return value 0. MSI (s) (70:FC) [08:56:24:050]: Machine policy value 'MaxPatchCacheSize' is 10 Action start 8:56:24: CostInitialize. MSI (s) (70:FC) [08:56:24:080]: PROPERTY CHANGE: Adding ROOTDRIVE property. Its value is 'c:'. MSI (s) (70:FC) [08:56:24:080]: PROPERTY CHANGE: Adding CostingComplete property. Its value is '0'. MSI (s) (70:FC) [08:56:24:080]: Note: 1: 2205 2: 3: Patch MSI (s) (70:FC) [08:56:24:080]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (70:FC) [08:56:24:080]: Note: 1: 2205 2: 3: MsiPatchHeaders MSI (s) (70:FC) [08:56:24:080]: Note: 1: 2205 2: 3: __MsiPatchFileList MSI (s) (70:FC) [08:56:24:080]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (70:FC) [08:56:24:080]: Note: 1: 2228 2: 3: PatchPackage 4: SELECT `DiskId`, `PatchId`, `LastSequence` FROM `Media`, `PatchPackage` WHERE `Media`.`DiskId`=`PatchPackage`.`Media_` ORDER BY `DiskId` MSI (s) (70:FC) [08:56:24:080]: Doing action: FileCost Action ended 8:56:24: CostInitialize. Return value 1. MSI (s) (70:FC) [08:56:24:090]: Note: 1: 2262 2: Class 3: -2147287038 MSI (s) (70:FC) [08:56:24:090]: Note: 1: 2262 2: Extension 3: -2147287038 MSI (s) (70:FC) [08:56:24:090]: Note: 1: 2262 2: TypeLib 3: -2147287038 Action start 8:56:24: FileCost. MSI (s) (70:FC) [08:56:24:090]: Doing action: IsolateComponents Action ended 8:56:24: FileCost. Return value 1. Action start 8:56:24: IsolateComponents. MSI (s) (70:FC) [08:56:24:090]: Doing action: CostFinalize Action ended 8:56:24: IsolateComponents. Return value 0. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding OutOfDiskSpace property. Its value is '0'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding OutOfNoRbDiskSpace property. Its value is '0'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceAvailable property. Its value is '0'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceRequired property. Its value is '0'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceRemaining property. Its value is '0'. MSI (s) (70:FC) [08:56:24:090]: Note: 1: 2205 2: 3: Patch MSI (s) (70:FC) [08:56:24:090]: Note: 1: 2262 2: Condition 3: -2147287038 MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding TARGETDIR property. Its value is 'c:'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying TempFolder property. Its current value is 'C:DOCUME~1RickHLOCALS~1Temp'. Its new value: 'c:DOCUME~1RickHLOCALS~1Temp'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying WindowsFolder property. Its current value is 'C:WINDOWS'. Its new value: 'c:WINDOWS'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying CommonFilesFolder.DCA909F7_1890_4AD6_9EAE_3C9D956FE00B property. Its current value is 'C:Program FilesCommon Files'. Its new value: 'c:Program FilesCommon Files'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying LocalAppDataFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its current value is 'C:Documents and SettingsRickHLocal SettingsApplication Data'. Its new value: 'c:Documents and SettingsRickHLocal SettingsApplication Data'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding LocalAppDataPCHealth.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTH'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding LocalAppDataErrorReporting.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREP'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WatsonUQSignoffFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREPQSIGNOFF'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WatsonUQRegularFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREPQREGULAR'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WatsonUQHeadlessFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREPQHEADLES'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying ProgramFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its current value is 'C:Program Files'. Its new value: 'c:Program Files'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying CommonFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its current value is 'C:Program FilesCommon Files'. Its new value: 'c:Program FilesCommon Files'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding SharedFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Program FilesCommon FilesMicrosoft Shared'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding DWFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Program FilesCommon FilesMicrosoft SharedDW'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding DWIntlFolder_1033.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Program FilesCommon FilesMicrosoft SharedDW1033'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying WindowsFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its current value is 'C:WINDOWS'. Its new value: 'c:WINDOWS'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WindowsPCHealth.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:WINDOWSPCHEALTH'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WindowsErrorReporting.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:WINDOWSPCHEALTHERRORREP'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WatsonAQSignoffFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:WINDOWSPCHEALTHERRORREPQSIGNOFF'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WatsonAQHeadlessFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:WINDOWSPCHEALTHERRORREPQHEADLES'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WindowsINFFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:WINDOWSINF'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its current value is 'C:WINDOWS'. Its new value: 'c:WINDOWS'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its current value is 'C:WINDOWSsystem32'. Its new value: 'c:WINDOWSsystem32'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WinSxsDirectory.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxs'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding policydir_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding payload.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WinSxsManifests.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsManifests'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WinSxsPolicies.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsPolicies'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding policydir.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsPoliciesx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_77c24773'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding payload_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsx86_policy.8.0.microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_5c4003bc63e949f6'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its current value is 'C:WINDOWS'. Its new value: 'c:WINDOWS'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its current value is 'C:WINDOWSsystem32'. Its new value: 'c:WINDOWSsystem32'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WinSxsDirectory.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxs'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding policydir_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WinSxsPolicies.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsPolicies'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding policydir.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsPoliciesx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_4428b63a'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WinSxsManifests.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsManifests'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding payload_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsx86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_db5f52fb98cb24ad'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying ProgramFilesFolder property. Its current value is 'C:Program Files'. Its new value: 'c:Program Files'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding INSTALLSQLDIR property. Its value is 'c:Program FilesMicrosoft SQL Server'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Ver.EF99D297_8F3F_42F1_8766_460250F41CDA property. Its value is 'c:Program FilesMicrosoft SQL Server90'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding InstallDir.EF99D297_8F3F_42F1_8766_460250F41CDA property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup Bootstrap'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPA.EF99D297_8F3F_42F1_8766_460250F41CDA property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARes1033.EF99D297_8F3F_42F1_8766_460250F41CDA property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA1033'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding SqlVer.41746B4B_478E_4AF6_946E_774617467ABF property. Its value is 'c:Program FilesMicrosoft SQL Server90'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding INSTALLDIR.41746B4B_478E_4AF6_946E_774617467ABF property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup Bootstrap'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPA.41746B4B_478E_4AF6_946E_774617467ABF property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding SqlVer.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding INSTALLDIR.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup Bootstrap'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPA.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPASchemas.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPASchemas'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepository.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepository'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryDBUNWRI.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDBUNWRITABLE_UPGBLKR'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinDBUNWRI.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDBUNWRITABLE_UPGBLKRin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryYukUPBlock.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryYUK1_UPGBLKR'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinYukUPBlock.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryYUK1_UPGBLKRin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryRSDIIS.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIIS'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinRSDIIS.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIISin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryRSCA.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMASSEMBLIES'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinRSCA.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMASSEMBLIESin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryResDBID.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRESERVEDATABASEID'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinResDBID.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRESERVEDATABASEIDin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryLogin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryLOGINNAMEASSERVERROLE'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinLogin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryLOGINNAMEASSERVERROLEin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryDUPSid.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATESID'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinDUPSid.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATESIDin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryDUPIdx.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATEINDEX_UPGBLKR'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinDUPIdx.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATEINDEX_UPGBLKRin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryASP.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryASPNETUSERENCRYPTED'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinASP.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryASPNETUSERENCRYPTEDin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding RSDEFAULTIISYUKON.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIISYUKON'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding RSDEFAULTIISYUKON_bin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIISYUKONin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding RSCUSTOMSECURITY.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMSECURITY'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding RSCUSTOMSECURITY_bin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMSECURITYin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPAbin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPAin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Ver.741C00B4_26BA_4E42_B590_3D7E63AF2EC4 property. Its value is 'c:Program FilesMicrosoft SQL Server90'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Gac.741C00B4_26BA_4E42_B590_3D7E63AF2EC4 property. Its value is 'c:Program FilesMicrosoft SQL Server90GAC'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Ver.117A1A21_ACE1_414A_88CC_83C84195F101 property. Its value is 'c:Program FilesMicrosoft SQL Server90'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Gac.117A1A21_ACE1_414A_88CC_83C84195F101 property. Its value is 'c:Program FilesMicrosoft SQL Server90GAC'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Ver.4845A713_8D8A_4100_8CAA_164C5AC9E452 property. Its value is 'c:Program FilesMicrosoft SQL Server90'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Gac.4845A713_8D8A_4100_8CAA_164C5AC9E452 property. Its value is 'c:Program FilesMicrosoft SQL Server90GAC'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Ver.3512ABB7_9344_4EF4_BCF5_984E466B5161 property. Its value is 'c:Program FilesMicrosoft SQL Server90'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Gac.3512ABB7_9344_4EF4_BCF5_984E466B5161 property. Its value is 'c:Program FilesMicrosoft SQL Server90GAC'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Ver.476E40C2_BF50_44F5_B79F_85F11E8470B6 property. Its value is 'c:Program FilesMicrosoft SQL Server90'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Gac.476E40C2_BF50_44F5_B79F_85F11E8470B6 property. Its value is 'c:Program FilesMicrosoft SQL Server90GAC'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding SqlVer.8DFD65FF_E015_42C8_B398_112982807348 property. Its value is 'c:Program FilesMicrosoft SQL Server90'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding SqlVer.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08 property. Its value is 'c:Program FilesMicrosoft SQL Server90'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding INSTALLDIR property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup Bootstrap'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding finish1033.8DFD65FF_E015_42C8_B398_112982807348 property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup Bootstrap1033'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding RES.8DFD65FF_E015_42C8_B398_112982807348 property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapResources'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Res11033.8DFD65FF_E015_42C8_B398_112982807348 property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapResources1033'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Help.8DFD65FF_E015_42C8_B398_112982807348 property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapHelp'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Res21033.8DFD65FF_E015_42C8_B398_112982807348 property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapHelp1033'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding SETUPBIN property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding SETUPLOG property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapLog'. MSI (s) (70:FC) [08:56:24:090]: Target path resolution complete. Dumping Directory table... MSI (s) (70:FC) [08:56:24:090]: Note: target paths subject to change (via custom actions or browsing) MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: TARGETDIR , Object: c: MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: TempFolder , Object: c:DOCUME~1RickHLOCALS~1Temp MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: WindowsFolder , Object: c:WINDOWS MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: CommonFilesFolder.DCA909F7_1890_4AD6_9EAE_3C9D956FE00B , Object: c:Program FilesCommon Files MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: LocalAppDataFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Documents and SettingsRickHLocal SettingsApplication Data MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: LocalAppDataPCHealth.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTH MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: LocalAppDataErrorReporting.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREP MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: WatsonUQSignoffFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREPQSIGNOFF MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: WatsonUQRegularFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREPQREGULAR MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: WatsonUQHeadlessFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREPQHEADLES MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: ProgramFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Program Files MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: CommonFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Program FilesCommon Files MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: SharedFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Program FilesCommon FilesMicrosoft Shared MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: DWFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Program FilesCommon FilesMicrosoft SharedDW MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: DWIntlFolder_1033.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Program FilesCommon FilesMicrosoft SharedDW1033 MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: WindowsFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:WINDOWS MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: WindowsPCHealth.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:WINDOWSPCHEALTH MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: WindowsErrorReporting.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:WINDOWSPCHEALTHERRORREP MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WatsonAQSignoffFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:WINDOWSPCHEALTHERRORREPQSIGNOFF MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WatsonAQHeadlessFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:WINDOWSPCHEALTHERRORREPQHEADLES MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WindowsINFFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:WINDOWSINF MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWS MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWSsystem32 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WinSxsDirectory.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxs MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: policydir_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: payload.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WinSxsManifests.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsManifests MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WinSxsPolicies.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsPolicies MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: policydir.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsPoliciesx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_77c24773 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: payload_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsx86_policy.8.0.microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_5c4003bc63e949f6 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWS MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWSsystem32 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WinSxsDirectory.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxs MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: policydir_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WinSxsPolicies.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsPolicies MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: policydir.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsPoliciesx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_4428b63a MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WinSxsManifests.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsManifests MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: payload_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsx86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_db5f52fb98cb24ad MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: ProgramFilesFolder , Object: c:Program Files MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: INSTALLSQLDIR , Object: c:Program FilesMicrosoft SQL Server MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Ver.EF99D297_8F3F_42F1_8766_460250F41CDA , Object: c:Program FilesMicrosoft SQL Server90 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: InstallDir.EF99D297_8F3F_42F1_8766_460250F41CDA , Object: c:Program FilesMicrosoft SQL Server90Setup Bootstrap MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPA.EF99D297_8F3F_42F1_8766_460250F41CDA , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARes1033.EF99D297_8F3F_42F1_8766_460250F41CDA , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA1033 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SqlVer.41746B4B_478E_4AF6_946E_774617467ABF , Object: c:Program FilesMicrosoft SQL Server90 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: INSTALLDIR.41746B4B_478E_4AF6_946E_774617467ABF , Object: c:Program FilesMicrosoft SQL Server90Setup Bootstrap MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPA.41746B4B_478E_4AF6_946E_774617467ABF , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SqlVer.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: INSTALLDIR.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup Bootstrap MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPA.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPASchemas.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPASchemas MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepository.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepository MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryDBUNWRI.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDBUNWRITABLE_UPGBLKR MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinDBUNWRI.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDBUNWRITABLE_UPGBLKRin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryYukUPBlock.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryYUK1_UPGBLKR MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinYukUPBlock.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryYUK1_UPGBLKRin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryRSDIIS.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIIS MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinRSDIIS.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIISin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryRSCA.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMASSEMBLIES MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinRSCA.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMASSEMBLIESin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryResDBID.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRESERVEDATABASEID MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinResDBID.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRESERVEDATABASEIDin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryLogin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryLOGINNAMEASSERVERROLE MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinLogin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryLOGINNAMEASSERVERROLEin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryDUPSid.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATESID MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinDUPSid.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATESIDin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryDUPIdx.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATEINDEX_UPGBLKR MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinDUPIdx.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATEINDEX_UPGBLKRin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryASP.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryASPNETUSERENCRYPTED MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinASP.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryASPNETUSERENCRYPTEDin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: RSDEFAULTIISYUKON.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIISYUKON MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: RSDEFAULTIISYUKON_bin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIISYUKONin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: RSCUSTOMSECURITY.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMSECURITY MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: RSCUSTOMSECURITY_bin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMSECURITYin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPAbin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPAin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Ver.741C00B4_26BA_4E42_B590_3D7E63AF2EC4 , Object: c:Program FilesMicrosoft SQL Server90 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Gac.741C00B4_26BA_4E42_B590_3D7E63AF2EC4 , Object: c:Program FilesMicrosoft SQL Server90GAC MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Ver.117A1A21_ACE1_414A_88CC_83C84195F101 , Object: c:Program FilesMicrosoft SQL Server90 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Gac.117A1A21_ACE1_414A_88CC_83C84195F101 , Object: c:Program FilesMicrosoft SQL Server90GAC MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Ver.4845A713_8D8A_4100_8CAA_164C5AC9E452 , Object: c:Program FilesMicrosoft SQL Server90 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Gac.4845A713_8D8A_4100_8CAA_164C5AC9E452 , Object: c:Program FilesMicrosoft SQL Server90GAC MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Ver.3512ABB7_9344_4EF4_BCF5_984E466B5161 , Object: c:Program FilesMicrosoft SQL Server90 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Gac.3512ABB7_9344_4EF4_BCF5_984E466B5161 , Object: c:Program FilesMicrosoft SQL Server90GAC MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Ver.476E40C2_BF50_44F5_B79F_85F11E8470B6 , Object: c:Program FilesMicrosoft SQL Server90 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Gac.476E40C2_BF50_44F5_B79F_85F11E8470B6 , Object: c:Program FilesMicrosoft SQL Server90GAC MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SqlVer.8DFD65FF_E015_42C8_B398_112982807348 , Object: c:Program FilesMicrosoft SQL Server90 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SqlVer.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08 , Object: c:Program FilesMicrosoft SQL Server90 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: INSTALLDIR , Object: c:Program FilesMicrosoft SQL Server90Setup Bootstrap MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: finish1033.8DFD65FF_E015_42C8_B398_112982807348 , Object: c:Program FilesMicrosoft SQL Server90Setup Bootstrap1033 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: RES.8DFD65FF_E015_42C8_B398_112982807348 , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapResources MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Res11033.8DFD65FF_E015_42C8_B398_112982807348 , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapResources1033 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Help.8DFD65FF_E015_42C8_B398_112982807348 , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapHelp MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Res21033.8DFD65FF_E015_42C8_B398_112982807348 , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapHelp1033 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SETUPBIN , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SETUPLOG , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapLog MSI (s) (70:FC) [08:56:24:100]: PROPERTY CHANGE: Adding INSTALLLEVEL property. Its value is '1'. MSI (s) (70:FC) [08:56:24:100]: Disallowing installation of component: {1A6D8713-9116-44AE-BA60-4CF0E8C1D58B} since the same component with higher versioned keyfile exists Action start 8:56:24: CostFinalize. MSI (s) (70:FC) [08:56:24:120]: Doing action: ARPInstallLocation.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08 Action ended 8:56:24: CostFinalize. Return value 1. MSI (s) (70:FC) [08:56:24:120]: PROPERTY CHANGE: Adding ARPINSTALLLOCATION property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup Bootstrap'. Action start 8:56:24: ARPInstallLocation.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08. MSI (s) (70:FC) [08:56:24:120]: Doing action: SetODBCFolders Action ended 8:56:24: ARPInstallLocation.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08. Return value 1. MSI (s) (70:FC) [08:56:24:120]: Note: 1: 2205 2: 3: ODBCDriver MSI (s) (70:FC) [08:56:24:120]: Note: 1: 2228 2: 3: ODBCDriver 4: SELECT `ComponentId`,`Description`,`Directory_`, `ActionRequest`, `Installed`, `Attributes` FROM `ODBCDriver`, `Component` WHERE `ODBCDriver`.`Component_` = `Component` AND (`ActionRequest` = 1 OR `ActionRequest` = 2) MSI (s) (70:FC) [08:56:24:120]: Note: 1: 2205 2: 3: ODBCTranslator MSI (s) (70:FC) [08:56:24:120]: Note: 1: 2228 2: 3: ODBCTranslator 4: SELECT `ComponentId`,`Description`,`Directory_`, `ActionRequest`, `Installed`, `Attributes` FROM `ODBCTranslator`, `Component` WHERE `ODBCTranslator`.`Component_` = `Component` AND (`ActionRequest` = 1 OR `ActionRequest` = 2) Action start 8:56:24: SetODBCFolders. MSI (s) (70:FC) [08:56:24:120]: Doing action: MigrateFeatureStates Action ended 8:56:24: SetODBCFolders. Return value 0. MSI (s) (70:FC) [08:56:24:120]: Skipping MigrateFeatureStates action: feature settings already made Action start 8:56:24: MigrateFeatureStates. MSI (s) (70:FC) [08:56:24:120]: Doing action: InstallValidate Action ended 8:56:24: MigrateFeatureStates. Return value 0. MSI (s) (70:FC) [08:56:24:120]: Feature: SupportFiles; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: sqlspars.dll.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: sqlsval.dll.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: DbgHelp.dll.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: setup.exe.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: sqlcu.dll.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: xmlrw.dll.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: ARPWrapper.exe.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: SqlBoot.dll.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: RedistQFEKey.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: CancelAutoplay.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: setupsql9.chm.8DFD65FF_E015_42C8_B398_112982807348; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: sqlspars.rll.8DFD65FF_E015_42C8_B398_112982807348; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: setup.rll.8DFD65FF_E015_42C8_B398_112982807348; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: sqlcu.rll.8DFD65FF_E015_42C8_B398_112982807348; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: ARPWrapper.rll.8DFD65FF_E015_42C8_B398_112982807348; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: finish.txt.8DFD65FF_E015_42C8_B398_112982807348; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: finish_sku.txt.8DFD65FF_E015_42C8_B398_112982807348; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: uplevel.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Absent; Request: Local; Action: Null MSI (s) (70:FC) [08:56:24:120]: Component: downlevel_manifest.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: downlevel_payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: nosxs.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Absent; Request: Local; Action: Null MSI (s) (70:FC) [08:56:24:120]: Component: uplevel.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E; Installed: Absent; Request: Local; Action: Null MSI (s) (70:FC) [08:56:24:120]: Component: downlevel_manifest.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: ExceptionMessageBox.dll.476E40C2_BF50_44F5_B79F_85F11E8470B6; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: WizardFrameworkLite.dll.3512ABB7_9344_4EF4_BCF5_984E466B5161; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: SxSComp.FB6C1C52464E44DC8FDC03E5FCADA0D2; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: SxSComp.65B0CF1C908640AD8A72C6C615216394; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: Microsoft.SqlServer.GridControl.dll.4845A713_8D8A_4100_8CAA_164C5AC9E452; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: Microsoft.SqlServer.Setup.117A1A21_ACE1_414A_88CC_83C84195F101; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: SxSComp.D7B464C2927E4A57AC167006E343B1A1; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: SxSComp.A6AED2EF66B84CCCB5FC3C32CF6E2253; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: MS.Sql.CustomControls.dll.741C00B4_26BA_4E42_B590_3D7E63AF2EC4; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: SxSComp.7CFE79FEC34C4C79B0387EF66E24ECA0; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: SxSComp.A3A47DFCA5F64B03AC400222997E22E9; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: Sql_AsmPublicKeys.6E1C5F41_647A_4340_A91C_FC4906A1EC10; Installed: Absent; Request: Local; Action: Null MSI (s) (70:FC) [08:56:24:120]: Component: MSS.AnalysisServices.UA.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: MSS.BestPracticesAnalyzer.UA.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: MSS.DTS.UA.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: MSS.NotificationServices.UA.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: MSS.SString.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: MSS.UpgradeAdvisor.UaEngine.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: MSS.UpgradeAdvisor.UaInterface.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: UACmd.exe.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: bpacmd.exe.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: BpaCmdX.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: SQLBPA.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: SQLSORT.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: SQLDATA.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: BPAClient.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: bpacommon.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: BPAdmin.exe.config.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: BPAServer.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: BPLib.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: bpa.RSCUSTOMSECURITY.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: bpa.RSDEFAULTIISYUKON.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: bpa.ASPNETUSERENCRYPTED.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: bpa.DUPLICATEINDEX_UPGBLKR.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: bpa.DUPLICATESID.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: bpa.LOGINNAMEASSERVERROLE.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: bpa.RESERVEDATABASEID.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: bpa.RSCUSTOMASSEMBLIES.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request:
I've been developing a vb app with sql server 2005 and had planned to use express as the client server so the db could be distributed with the app. After importing 21 csv text files, I realized that I have way too much data. My understanding is that sqlexpress can only work with max 4gb database.
The 21 csv files (total 925mb) brought the db size up to 1.5gb and I still have at least 250 more files to go. Obviously, I need a different approach. What are the size limitations of the non express version of sql server 2005? Any suggestions on the best approach for this type of situation?
Hello,I'm looking for a tutorial or some sample code to save a file in sql server with c#. So far I have not been able to find a anything I could use as most tutorials are in VB. I'm using the varbinary max type to store the file. The part I need help with is selecting the file and converting it using the Stream object, not the SQL insert statements. Thanks,Arnold
"[Flat File Destination [13]] Error: Data conversion failed. The data conversion for column "SDATA" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". " "[Flat File Destination [13]] Error: Cannot copy or convert flat file data for column "SDATA". " "[DTS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Flat File Destination" (13) failed with error code 0xC02020A0. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. " "[DTS.Pipeline] Error: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC02020A0. There may be error messages posted before this with more information on why the thread has exited. " "[DataReader Source [207]] Error: The component "DataReader Source" (207) was unable to process the data. " "[DTS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "DataReader Source" (207) returned error code 0xC02090F5. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. " "[DTS.Pipeline] Error: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited. "
I am selecting data from an OBDC then copying it to a text file an I always get this error, but when I change the destination to a excel file it works perfectly. But the whole point of the package is to copy to a text file.
Please could you help me, your replies will be greatly appreciated.
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.
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.
Hello there,I just want to ask if storing data in dbase is much better than storing it in the file system? Because for one, i am currenlty developing my thesis which uploads a blob.doc file to a web server (currently i'm using the localhost of ASP.NET) then retrieves it from the local hostAlso i want to know if im right at this, the localhost of ASP.NET is the same as the one of a natural web server on the net? Because i'm just thinking of uploading and downloading the files from a web server. Although our thesis defense didn't require us to really upload it on the net, we were advised to use a localhost on our PC's. I'll be just using my local server Is it ok to just use a web server for storing files than a database?
Hello Everyone, I am trying to restore a bak file which came with code for a tutorial. I think it is safe to restore, but sql server 2005 express has the following problem when I try to restore it. TITLE: Microsoft SQL Server Management Studio Express------------------------------ Restore failed for Server 'BOBSQLEXPRESS'. (Microsoft.SqlServer.Express.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476 ------------------------------ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:Program Files (x86)Microsoft SQL ServerMSSQL.1MSSQLDashboard.mdf'. (Microsoft.SqlServer.Express.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476 The links given for help have no information about the problem and I'm not really sure where I should be looking to solve this. I'm a newbie to databases so if you could provide a step-by-step answer that would be best. Thanks in advance. Robert
Hi All, I have a .sql file with all my queries written in it. Now I want to know, Is it possible to run this sql file in SQL Server 2005 Express Edition like we can do in Oracle? If it is possible then tell me how to do it?Thanx in advance for any kind of help.Regards,Paramhans Dubey.
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
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.
Hi Guys, how many connections does sql 2005 express allow to .mdf file. I stumpled on info on a microsoft site (actually a forum post on msdn) that sql server express allows only a single connection to an .mdf file. Iam intrested in this because i developed reporting services reports in BIS and iam having problems. If i run a report from report manager, i have to wait for close to 20 minutes before i can be able to run my asp.net application agian. Else if i insert data or retrieve data from my asp.net application, then i have to wait again for 20 minutes or more before i can be able to run my reports else i will get an error that a connection can not be made to the database or that the database is being used by another process. So in all cases, i have to wait for 20--30 minutes before a connection can be made to the .mdf file. i.e after running a report or after inserting or retrieving data from the database through my asp.net application. Iam using sql sever 2005 express with advanced services and visual web developer on windows server 2003. Any ideas or help.
All -- Please help. Is it possible to connect to MDF file without having SQL Server 2005 Express installed on the machine? That is-- can one connect directly to an MDF in the same way and Access MDB file can be used? If no, then is there any way around this? If yes, then are there any limitations? Please advise. Thank you. -- Mark Kamoski
I am new to SQL Server, and migrating part of an Access application toSSE. I am trying to insert a comma delimited file into SSE 2005. I amable to run a BULK INSERT statement on a simple file, specifying thefield (,) and row () terminators. I can also do the same with aformat file.Here is the problem. My csv file has 185 columns, with a mixture ofdatatypes. Sometimes, a text field will contain the field delimiter aspart of the string. In this case (and only in this case) there will bedouble quotes around the string to indicate that the comma is part ofthe field, and not a delimiter.Is there any way to indicate that there is a text delimiter that isonly present some of the time?If not, any suggestions on getting the data into SSE?Many thanks for your input.Cheryl
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:
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!?
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
Okay, I know the maximum size limit on a database in SQL 2005 Express is 4GB, but what happens when you exceed that limit? I can't seem to find much info on that topic. What kind of error return would you get from a stored procedure attempting to do an insert that will exceed the 4GB limitation? Also what factors go into that maximum size, factors that might not be completely obvious of course?
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
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?
I have records with 50 plus fields of data.I was thinking of writing all the fields data into a XML file and then store it in a SQL server database for retrieval later on.Is there anyway i can go about doing this?
hi i have a database file backup which is having no extension (eg saims) . Can i create a database using this backup in sql server expression edition. Or else is there any way to get the .mdf file from sql server 2005 full edition?????????????? Thanx in advance
When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media.
How can apply SQL Server 2005 Express SP1 to update this existing instance?
Currently, if I run this query:
SELECT @@version
I get the following:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
After applying SP1, I should get 9.00.2047.00.
Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1:
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!!!
Hi, i am using command files(.cmd) and osql utility to conneft to a database. following is the requirement. I have a query "SELECT top 1 au_fname FROM pubs..authors".
Can i store the value of au_fname in the command file?
I am using FileUpload control in ASP.net 2.0 to upload files and store them into SQL server database as an image. I am fine with MS office files, image files and etc. We have Product Center (Proe) engineering software to configure parts and the files generated through this software have PLT extension when I store these files, the file type is Plian/text. I am using Fileupload.PostedFile.Content to get the file type. How can I store PLT, TIF files in SQL server? Please help.
I am looking for some microsoft recommendation on storing images in SQL Server Vs File System. Here is what our requirement is.
Currently we are using SQL Server 2000 with a VB6(COM+) & ASP front end. Our architecture involves Log Shipping & Replication. We use log shipping for our DR site and Replication to replicate to Datawarehouse & DB2 enviornment. I have been trying to research this topic and have come up with opinion favoring both sides mostly file system but nobody seems to point any Microsoft recommendation.
With our application we are looking for Transactions, backups, Log shipping & replication with these images. I have read MS implementation of TerraServer and there they recommend storing them in SQL Server if above is required. (https://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part3/c1161.mspx?mfr=true)
Can somebody please point me to some Microsoft recommendation and what does SQL Server 2005 offers in this aspect.
