Each client has 5 Full-Text Catalogs. For ease of explanation let€™s call the FTCs C1 thru C5.
Now each client€™s FTCs are named the SAME. So each client has FTCs named C1, C2, C3, C4 and C5.
I need to move the clients to our new SQL Server 2005 Enterprise server.
I can backup up the DB using the native SQL Server 2000 backup command but that of course does not back up the FTCs.
So once I restore the client DB over to the new SS2K5 server, how do I re-enable the FTCs and rebuild them so that they are the same as what was over on the SS2K server.
Also, after the first client is complete, will I run into a duplicate FTC error when I try to recreate the subsequent clients on the server since they all have the same named FTCs?
Hi all, I face a problem as follows: We have an application runnig on SS2K.We log every delete of
documents(from Archive table) in another table.Now it seems some of the rows have deleted strangely
without any delete log by our application.We assumed there is somebody who has direct access to
database and delete them manually(obviousely our app does not generate any log in this situation)But
there is no people.We check that with admins many times. Does SQL Server itself deletes rows for any reason? How can I know what is happening?Do you think
our app flaws somewhere? Thanks a lot for your attention.
Hi all, I face a problem as follows: We have an application runnig on SS2K.We log every delete of documents(from Archive table) in another table. Now it seems some of the rows have deleted strangely without any delete log by our application.We assumed there is somebody who has direct access to database and delete them manually(obviousely our app does not generate any log in this situation)But there is no people.We check that with admins many times. Does SQL Server itself deletes rows for any reason? How can I know what is happening?Do you think our app flaws somewhere?
i think this feature is so crappy compare to the one from 2000. Because once you create the linked server you are not able to see the tables as you can do it on 2000.
how do you expect someone to query the tables if its not there.
I am in need of some answers on SS2K5 Encryption and possible issues when used in a clustered(replicated) configuration as well as having the encryption work on a Test/UAT configuration.
Here is the scenerio:
ServerA - is the Primary/Active server in a NeverFail cluster. NeverFail is a replication method like MS Clustering is except NF replicates the server to EXACT mirrors of each other.
ServerA has lets say 2 client DBs (actually we have 10-20 but for simplicity we will say 2.)
ServerB is the Secondary/Passive node.
First question is ... what issues may I run into if I encrypt the 2 clients needed data in the DBs and we then have a failover. I figure we should not see an issue if NeverFail is replicating everything including the machines SIDs.
Now for the second question:
We also have a Test/UAT server that we restore backups from the production clusters. On this server we have upwards of 60+ DBs from 8 different NeverFail clusters.
What are the issues that I may encounter in this scenerio?
I thought that each server generates its own master key per instance of SQL Server.
SO how will I bring that master key over to the Test/UAT server and use it knowing I will also need to have the other 7 master keys from the other 7 clusters?
I am sure this initial post will generate more conversation and probably will need more details on my behalf but I wanted to start out simple and dive into this issue.
Hi all, I have seen in documents that I can install SS2K on a machine without network domain connection using a domain account.It said that domain accounts are prefered according to some reasons and it is not limited to machines on a domain so you should do it on a single PC. I tried this during installation and entered many different things but no chance: <OS_account> <machine_name>/<OS_account> ... Would you please telling me what should I enter as service starter account if I want to use domain users? -Thanks in advance
Is it possible to create a Pull Subscription on a named instance in SQL Server 2000 Developer Edition? When I try, I get an error message 14234 saying that it can't find the value '@server'. Its hint is to look for the server in sp_helpserver. When I go to QA and connect to that named instance and run sp_helpserver, I see it there.
I've been doing some testing on the SAN/Disk subsystem over the past few days. I've run into something that is bugging me though. Hopefully someone here has run into the same thing or can answer.
*All LUNs have been created with default selects.
Test 1: LUN1 (H:) - Created partition with diskmanager in win2003. LUN2 (I:) - Created partition with diskpart and aligned the sectors at 64k. Formatted both disks to have 4k in the allocation units. Created a new blank DB on each disk. With Profiler running, I ran a bulk insert for both disks and also ran a "Select count(*), Sum(total) from tableA" for both databases and cleared the proc cache inbetween. Profiler showed the reads and writes io for the import and selects as a the same number (468721 reads and 312182 writes).
Test 2: Deleted partitions LUN1 (H:) - Created partition with diskmanager in win2003. LUN2 (I:) - Created partition with diskpart and aligned the sectors at 64k. Formatted both disks to have 8k in the allocation units. Created a new blank DB on each disk. With Profiler running, I ran a bulk insert for both disks and also ran a "Select count(*), Sum(total) from tableA" for both databases and cleared the proc cache inbetween. Profiler showed the reads and writes io for the import and selects as a the same number (468721 reads and 312182 writes).
Test 3: Same as test 2 but formatted with 64k allocation units.
So here is my question: Shouldn't the I/O go down or at least change if you change the allocation unit size for the disk?
Our software applications require the sa login to be enabled. We have a .NET (C#) installation application that installs our software applications.
So, is there any way that we can programmatically enable the sa login for SQL Server 2005? Ideally, we'd like to code this into our installation application.
I have a couple of tables set up with column level tracking and using the "Subscriber Always Wins" conflict resolver.
I am still trying to work out why there is a conflict as the only updates to these rows happen at the subscriber.
What I am finding is that a conflict occurs and there appears to be a delay between the conflict being recognised and then resolved.
The reason I know there is a delay is because this is playing havoc with a data extract that relies on the updates from the subscriber.
For instance, I have a job on which the status is changed. That status change triggers an extract via BizTalk to another system. BizTalk, via an SQL adapter extracts the data from the server and I find that some of it is missing in the extract.
I go and look into the database at the raw data and find that the data is in fact there.
I have certain triggers running which set up export flags in the database to say this data should be exported. This works perfectly when there are no conflicts.
In each case where data has not been extracted, a conflict occurs.
Is there any way to guarantee that the conflict will be resolved at the same time as the synchronisation is complete - i.e. within the same transaction?
I thought replication was supposed to be a single transaction - you get it all or you get nothing.
I'm interested to hear from anyone who has experienced this behaviour.
Hi Settled into the new giggero now. Since I have moved here we have upgraded our 4 SQL Servers to 2005 64 bit. All 2 proc dual core hyper threaded with 4GB RAM. Windows 2003. SQL Server compatibility level is 90. SP 1 and the CTP for SP2 are installed. We are hanging on with sp2. Maxdop is 0 (but has been tried on 2). Up to a score or so databases per machine, between 8 and 300 GB in size. Offline, reasonably heavy duty ETL batch processing. Since upgrading we have had trouble with the CPUs intermittently maxing out at 100% usage. This is when intensive routines are run. We know that many of these routines are crappy (SELECT... INTO creating tables with 10s or 100s of millions of rows, cursors etc.) and we are rewriting the code. Estimated time of completion of code review and rewrite is end of next year so we can't wait that long. The same poor code ran (albeit slowly) in SS2k but is causing the server to lock up now it is being run on SS2k5. Symptoms include connection attempts timing out, routines running very slowly. Existing connections can continue to make requests but these are very slow. If we get on the box the CPUs are at a never wavering 100% utilisation. This continues until intervention is taken, often restarting the service. We have left a maxed out box alone over a weekend and it was still in the same state when we came in on Monday. Nothing to glean from the error logs (AFAIK). Obviously the long term fix is to get the code sorted but this is an ongoing process (in fact it is one of the reasons I was hired). Our immediate concern is to get the servers back up to the sort of performance we were realising before we upgraded. Does anyone have any ideas?As ever eternal gratitude and a crate of virtual beer for any help :D
Has anyone run into the issue of installing SP1 on a 2003 R2 server?
I have seen a post or two on other sites but I cannot seem to find them again.
Install goes great up until it comes to the upgrading of SSIS (Integration Services).
At that point is fails with the error of:
A recently applied update, KB913090, failed to install.
This is a dialog box that I hit the "send error report" button. It then goes to the upgrading of the Client Components (CC) and fails with the same error message of:
A recently applied update, KB913090, failed to install.
The ugrade the continues after I hit the same "send error report"button.
ALL of the other steps complete with SUCESSFULLY. Only the SSIS and Client Components show a failed status in the Installation Prog
In the Installation Complete screen, I can highlight both the SSIS and CC and see an additional error of:
Unable to install Windows Installer MSP file
I then can hit the View Log button (which I have done for the SSIS step) and see the error log but I am having a tough time making heads or tails of it.
I have attached the output from the SSIS error log below.
I have a couple of questions:
1. Is the install of SP1 good for all the other steps that completed successfully
2. Has anyone had issues with installing SP1 on a Windows 2003 R2 server? I have installed SP1 on other Windows 2003 servers NOT running R2 and it ran like a champ.
Thanks ALL!
====== ERROR LOG FROM SSIS UPGRADE ============================================
01/07/2007 19:23:23.247 ================================================================================ 01/07/2007 19:23:23.247 Hotfix package launched 01/07/2007 19:23:23.747 Product discovery successfully completed during the install process for DTS 01/07/2007 19:23:23.762 SP Level check successfully completed during the install process for DTS 01/07/2007 19:23:23.778 Product language check successfully completed during the install process for DTS 01/07/2007 19:23:23.793 Product version check successfully completed during the install process for DTS 01/07/2007 19:23:23.825 Command-line instance name check completed during the install process 01/07/2007 19:23:23.840 Baseline build check completed during the install process 01/07/2007 19:28:41.393 Attempting to install instance: DTS 01/07/2007 19:28:41.408 Attempting to install target: AUS02DB13 01/07/2007 19:28:41.440 Attempting to check for locked files: sqlrun_dts.msp 01/07/2007 19:28:41.502 Attempting to check for locked files: \AUS02DB13g$2fe15a257eaedfc36c121fc912HotFixDTSFilessqlrun_dts.msp 01/07/2007 19:28:41.518 Creating MSP locked file check log at: C:WINDOWSHotfixDTS9LogsDTS9_Hotfix_KB913090_sqlrun_dts.msp.out 01/07/2007 19:28:48.799 MSP returned 1602: The user cancels installation. 01/07/2007 19:28:49.017 Successfully checked file: \AUS02DB13g$2fe15a257eaedfc36c121fc912HotFixDTSFilessqlrun_dts.msp 01/07/2007 19:28:49.033 Successfully opened registry key: SystemCurrentControlSetControlSession Manager 01/07/2007 19:28:49.064 Successfully read registry key: PendingFileRenameOperations 01/07/2007 19:28:49.080 Multi-string values: 01/07/2007 19:28:49.096 ??g:a4be8c9b1bce3ffa869bbb5137 01/07/2007 19:28:49.111 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerShared9.0.2047.0 C:Program FilesMicrosoft SQL ServerShareddbghelp.dll 01/07/2007 19:28:49.127 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedSqlDumper.exe 01/07/2007 19:28:49.142 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedSqlDumper.exe 01/07/2007 19:28:49.158 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedSqlDumper.exe 01/07/2007 19:28:49.174 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlsqm.exe 01/07/2007 19:28:49.205 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinndtsinstall.exe 01/07/2007 19:28:49.221 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsResourcesmsmdsrv.rll 01/07/2007 19:28:49.236 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsResourcesmsmdsrv.rll 01/07/2007 19:28:49.252 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsResourcesmsmdsrv.rll 01/07/2007 19:28:49.267 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsmsmdlocal.dll 01/07/2007 19:28:49.283 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsmsmdlocal.dll 01/07/2007 19:28:49.299 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsmsmdlocal.dll 01/07/2007 19:28:49.314 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponents9.0.2047.0 C:Program FilesMicrosoft SQL ServerSharedmsmdlo~1.dll 01/07/2007 19:28:49.330 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServerCe.Dts.Provider9.0.242.0__89845dcd8080cc91Microsoft.SqlServerCe.Dts.Provider.dll 01/07/2007 19:28:49.361 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DataStorage9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DataStorage.dll 01/07/2007 19:28:49.377 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.CustomControls9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.CustomControls.dll 01/07/2007 19:28:49.392 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.WizardFramework9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.WizardFramework.dll 01/07/2007 19:28:49.408 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices.Xmla9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.XMLA.dll 01/07/2007 19:28:49.424 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.OlapEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.OlapEnum.dll 01/07/2007 19:28:49.439 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.ActiveXScriptTask.xml 01/07/2007 19:28:49.455 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.ActiveXScriptTaskUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ActiveXScriptTaskUtil.dll 01/07/2007 19:28:49.470 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.ActiveXScriptTaskUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ActiveXScriptTaskUtil.dll 01/07/2007 19:28:49.486 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.ActiveXScriptTaskUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ActiveXScriptTaskUtil.dll 01/07/2007 19:28:49.517 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ActiveXScriptTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ActiveXScriptTask.dll 01/07/2007 19:28:49.533 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMicrosoft.SqlServer.ActiveXScriptTaskUtil.dll 01/07/2007 19:28:49.549 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.ActiveXScriptTask.dll 01/07/2007 19:28:49.580 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.DataTransformationServices.Controls9.0.242.0__89845dcd8080cc91Microsoft.DataTransformationServices.Controls.DLL 01/07/2007 19:28:49.595 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnDTSWizard.exe 01/07/2007 19:28:49.611 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5SDKAssembliesMicrosoft.SqlServer.TxScript.dll 01/07/2007 19:28:49.627 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsMicrosoft.SqlServer.TxScript.dll 01/07/2007 19:28:49.642 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TxScript9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TxScript.dll 01/07/2007 19:28:49.674 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSampling.dll 01/07/2007 19:28:49.689 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSampling.dll 01/07/2007 19:28:49.705 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSampling.dll 01/07/2007 19:28:49.720 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxRowCount.dll 01/07/2007 19:28:49.752 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxRowCount.dll 01/07/2007 19:28:49.767 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxRowCount.dll 01/07/2007 19:28:49.783 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Dts.DtsClient9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.Dts.DtsClient.dll 01/07/2007 19:28:49.799 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DataReaderDest9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DataReaderDest.dll 01/07/2007 19:28:49.814 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMicrosoft.SqlServer.Dts.DtsClient.dll 01/07/2007 19:28:49.830 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsMicrosoft.SqlServer.DataReaderDest.dll 01/07/2007 19:28:49.830 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.TransferSqlServerObjectsTask.xml 01/07/2007 19:28:49.845 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferSqlServerObjectsTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferSqlServerObjectsTask.dll 01/07/2007 19:28:49.877 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TransferSqlServerObjectsTask.dll 01/07/2007 19:28:49.892 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.TransferStoredProceduresTask.xml 01/07/2007 19:28:49.908 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.TransferLoginsTask.xml 01/07/2007 19:28:49.924 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.TransferJobsTask.xml 01/07/2007 19:28:49.939 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.TransferErrorMessagesTask.xml 01/07/2007 19:28:49.970 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.TransferDatabasesTask.xml 01/07/2007 19:28:49.986 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TransferStoredProceduresTask.dll 01/07/2007 19:28:50.002 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TransferLoginsTask.dll 01/07/2007 19:28:50.002 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TransferJobsTask.dll 01/07/2007 19:28:50.033 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TransferErrorMessagesTask.dll 01/07/2007 19:28:50.033 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TransferDatabasesTask.dll 01/07/2007 19:28:50.049 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TransferObjectsTask.dll 01/07/2007 19:28:50.064 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferStoredProceduresTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferStoredProceduresTask.dll 01/07/2007 19:28:50.080 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferLoginsTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferLoginsTask.dll 01/07/2007 19:28:50.095 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferJobsTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferJobsTask.dll 01/07/2007 19:28:50.111 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferErrorMessagesTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferErrorMessagesTask.dll 01/07/2007 19:28:50.111 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferDatabasesTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferDatabasesTask.dll 01/07/2007 19:28:50.127 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferObjectsTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferObjectsTask.dll 01/07/2007 19:28:50.142 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DtsTransferProvider9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DtsTransferProvider.dll 01/07/2007 19:28:50.158 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TableTransferGeneratorTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TableTransferGeneratorTask.dll 01/07/2007 19:28:50.174 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMicrosoft.SqlServer.DtsTransferProvider.dll 01/07/2007 19:28:50.189 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TableTransferGeneratorTask.dll 01/07/2007 19:28:50.189 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxTermExtraction.dll 01/07/2007 19:28:50.205 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxTermExtraction.dll 01/07/2007 19:28:50.220 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxTermExtraction.dll 01/07/2007 19:28:50.236 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxTermLookup.dll 01/07/2007 19:28:50.252 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxTermLookup.dll 01/07/2007 19:28:50.267 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxTermLookup.dll 01/07/2007 19:28:50.283 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnResources.90.2047.0 E:MSSQLMSSQLSS2K5DTSBinnResourcesdts.rll 01/07/2007 19:28:50.283 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnResourcesdtsconn.rll 01/07/2007 19:28:50.299 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnResourcesdtsconn.rll 01/07/2007 19:28:50.314 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnResourcesdtsconn.rll 01/07/2007 19:28:50.330 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSForEachEnumeratorsenMicrosoft.SqlServer.ForEachAdoEnumerator.xml 01/07/2007 19:28:50.345 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSForEachEnumeratorsenMicrosoft.SqlServer.ForEachSMOEnumerator.xml 01/07/2007 19:28:50.377 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSConnectionsenMicrosoft.SqlServer.ManagedConnections.xml 01/07/2007 19:28:50.392 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnDTSPipelinePerf.dll 01/07/2007 19:28:50.408 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnResourcesdtspipeline.rll 01/07/2007 19:28:50.408 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnResourcesdtspipeline.rll 01/07/2007 19:28:50.424 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnResourcesdtspipeline.rll 01/07/2007 19:28:50.439 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.FtpTask.xml 01/07/2007 19:28:50.455 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.FtpTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.FtpTask.dll 01/07/2007 19:28:50.470 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.FtpTask.dll 01/07/2007 19:28:50.486 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.ExecProcTask.xml 01/07/2007 19:28:50.517 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.SendMailTask.xml 01/07/2007 19:28:50.549 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.MSMQTask.xml 01/07/2007 19:28:50.580 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.MSMQUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.MSMQUtil.dll 01/07/2007 19:28:50.595 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.MSMQUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.MSMQUtil.dll 01/07/2007 19:28:50.595 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.MSMQUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.MSMQUtil.dll 01/07/2007 19:28:50.611 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.MSMQTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.MSMQTask.dll 01/07/2007 19:28:50.627 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMicrosoft.SqlServer.MSMQUtil.dll 01/07/2007 19:28:50.642 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMicrosoft.SqlServer.MSMQUtil.dll 01/07/2007 19:28:50.658 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMicrosoft.SqlServer.MSMQUtil.dll 01/07/2007 19:28:50.674 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.MSMQTask.dll 01/07/2007 19:28:50.689 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxMulticast.dll 01/07/2007 19:28:50.705 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxMulticast.dll 01/07/2007 19:28:50.705 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxMulticast.dll 01/07/2007 19:28:50.720 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsCommandDest.dll 01/07/2007 19:28:50.736 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsCommandDest.dll 01/07/2007 19:28:50.752 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsCommandDest.dll 01/07/2007 19:28:50.767 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxFileInserter.dll 01/07/2007 19:28:50.767 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxFileInserter.dll 01/07/2007 19:28:50.799 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxFileInserter.dll 01/07/2007 19:28:50.845 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxFileExtractor.dll 01/07/2007 19:28:50.845 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxFileExtractor.dll 01/07/2007 19:28:50.861 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxFileExtractor.dll 01/07/2007 19:28:50.877 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxLineage.dll 01/07/2007 19:28:50.892 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxLineage.dll 01/07/2007 19:28:50.908 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxLineage.dll 01/07/2007 19:28:50.924 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxUnPivot.dll 01/07/2007 19:28:50.924 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxUnPivot.dll 01/07/2007 19:28:50.955 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxUnPivot.dll 01/07/2007 19:28:50.955 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponents.90.2047.0 E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxPivot.dll 01/07/2007 19:28:50.970 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxMergeJoin.dll 01/07/2007 19:28:50.986 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxMergeJoin.dll 01/07/2007 19:28:51.002 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxMergeJoin.dll 01/07/2007 19:28:51.017 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponents.90.2047.0 E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxUnAll.dll 01/07/2007 19:28:51.033 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSort.dll 01/07/2007 19:28:51.033 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSort.dll 01/07/2007 19:28:51.049 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSort.dll 01/07/2007 19:28:51.064 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSplit.dll 01/07/2007 19:28:51.080 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSplit.dll 01/07/2007 19:28:51.080 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSplit.dll 01/07/2007 19:28:51.095 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxLookup.dll 01/07/2007 19:28:51.111 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxLookup.dll 01/07/2007 19:28:51.127 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxLookup.dll 01/07/2007 19:28:51.142 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxGroupDups.dll 01/07/2007 19:28:51.158 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxGroupDups.dll 01/07/2007 19:28:51.158 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxGroupDups.dll 01/07/2007 19:28:51.174 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxDerived.dll 01/07/2007 19:28:51.189 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxDerived.dll 01/07/2007 19:28:51.205 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxDerived.dll 01/07/2007 19:28:51.220 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxDataConvert.dll 01/07/2007 19:28:51.236 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxDataConvert.dll 01/07/2007 19:28:51.252 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxDataConvert.dll 01/07/2007 19:28:51.267 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxCopyMap.dll 01/07/2007 19:28:51.267 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxCopyMap.dll 01/07/2007 19:28:51.283 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxCopyMap.dll 01/07/2007 19:28:51.299 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxCharMap.dll 01/07/2007 19:28:51.314 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxCharMap.dll 01/07/2007 19:28:51.330 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxCharMap.dll 01/07/2007 19:28:51.345 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxBestMatch.dll 01/07/2007 19:28:51.345 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxBestMatch.dll 01/07/2007 19:28:51.361 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxBestMatch.dll 01/07/2007 19:28:51.377 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxAgg.dll 01/07/2007 19:28:51.392 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxAgg.dll 01/07/2007 19:28:51.408 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxAgg.dll 01/07/2007 19:28:51.424 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.XmlTask.xml 01/07/2007 19:28:51.439 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5dtsBinnatchparser90.dll 01/07/2007 19:28:51.455 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.SQLTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SQLTask.dll 01/07/2007 19:28:51.470 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnSQLTaskConnections.dll 01/07/2007 19:28:51.470 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnSQLTaskConnections.dll 01/07/2007 19:28:51.486 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnSQLTaskConnections.dll 01/07/2007 19:28:51.502 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.SQLTask.dll 01/07/2007 19:28:51.533 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsSqlDest.dll 01/07/2007 19:28:51.549 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsSqlDest.dll 01/07/2007 19:28:51.580 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsSqlDest.dll 01/07/2007 19:28:51.595 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5SDKAssembliesMicrosoft.SqlServer.ScriptTask.dll 01/07/2007 19:28:51.595 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ScriptTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ScriptTask.dll 01/07/2007 19:28:51.611 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.ScriptTask.dll 01/07/2007 19:28:51.627 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRecordSetDest.dll 01/07/2007 19:28:51.642 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRecordSetDest.dll 01/07/2007 19:28:51.658 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRecordSetDest.dll 01/07/2007 19:28:51.674 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRawSource.dll 01/07/2007 19:28:51.674 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRawSource.dll 01/07/2007 19:28:51.705 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRawSource.dll 01/07/2007 19:28:51.705 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRawDest.dll 01/07/2007 19:28:51.720 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRawDest.dll 01/07/2007 19:28:51.736 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRawDest.dll 01/07/2007 19:28:51.752 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.ASTasks.xml 01/07/2007 19:28:51.767 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ASTasks9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ASTasks.dll 01/07/2007 19:28:51.783 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.ASTasks.dll 01/07/2007 19:28:51.799 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsOleDbSrc.dll 01/07/2007 19:28:51.799 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsOleDbSrc.dll 01/07/2007 19:28:51.830 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsOleDbSrc.dll 01/07/2007 19:28:51.845 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsOleDbDest.dll 01/07/2007 19:28:51.845 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsOleDbDest.dll 01/07/2007 19:28:51.861 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsOleDbDest.dll 01/07/2007 19:28:51.892 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsFlatFileDest.dll 01/07/2007 19:28:51.908 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsFlatFileDest.dll 01/07/2007 19:28:51.908 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsFlatFileDest.dll 01/07/2007 19:28:51.924 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsFlatFileSrc.dll 01/07/2007 19:28:51.955 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsFlatFileSrc.dll 01/07/2007 19:28:51.955 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsFlatFileSrc.dll 01/07/2007 19:28:51.970 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.FileSystemTask.xml 01/07/2007 19:28:51.986 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.FileSystemTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.FileSystemTask.dll 01/07/2007 19:28:52.017 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.FileSystemTask.dll 01/07/2007 19:28:52.033 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnExecPackageTask.dll 01/07/2007 19:28:52.049 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.DmQueryTask.xml 01/07/2007 19:28:52.064 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DMQueryTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DmQueryTask.dll 01/07/2007 19:28:52.064 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.DmQueryTask.dll 01/07/2007 19:28:52.095 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.BulkInsertTask.xml 01/07/2007 19:28:52.111 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BulkInsertTaskConnections9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.BulkInsertTaskConnections.dll 01/07/2007 19:28:52.127 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BulkInsertTaskConnections9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.BulkInsertTaskConnections.dll 01/07/2007 19:28:52.142 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BulkInsertTaskConnections9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.BulkInsertTaskConnections.dll 01/07/2007 19:28:52.158 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.BulkInsertTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.BulkInsertTask.dll 01/07/2007 19:28:52.174 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMicrosoft.SqlServer.BulkInsertTaskConnections.dll 01/07/2007 19:28:52.189 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.BulkInsertTask.dll 01/07/2007 19:28:52.205 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.WMIEWTask.xml 01/07/2007 19:28:52.220 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.WMIDRTask.xml 01/07/2007 19:28:52.236 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.WebServiceTask.xml 01/07/2007 19:28:52.252 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.WebServiceTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.WebServiceTask.dll 01/07/2007 19:28:52.267 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.MaintenancePlanTasks9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.MaintenancePlanTasks.dll 01/07/2007 19:28:52.283 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.WebServiceTask.dll 01/07/2007 19:28:52.299 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.MaintenancePlanTasks.dll 01/07/2007 19:28:52.314 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsResourcesdtspipeline.rll 01/07/2007 19:28:52.330 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsResourcesdtspipeline.rll 01/07/2007 19:28:52.345 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsResourcesdtspipeline.rll 01/07/2007 19:28:52.345 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsexceldest.dll 01/07/2007 19:28:52.377 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsexceldest.dll 01/07/2007 19:28:52.392 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsexceldest.dll 01/07/2007 19:28:52.392 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsexcelsrc.dll 01/07/2007 19:28:52.408 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsexcelsrc.dll 01/07/2007 19:28:52.439 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsexcelsrc.dll 01/07/2007 19:28:52.439 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsMicrosoft.SqlServer.XMLSrc.dll 01/07/2007 19:28:52.455 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsMicrosoft.SqlServer.ADONETSrc.dll 01/07/2007 19:28:52.470 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.XmlSrc9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.XMLSrc.dll 01/07/2007 19:28:52.486 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ADONETSrc9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ADONETSrc.dll 01/07/2007 19:28:52.502 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.PipelineHost9.0.242.0__89845dcd8080cc91Microsoft.SQLServer.PipelineHost.dll 01/07/2007 19:28:52.517 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnDTSPipeline.dll 01/07/2007 19:28:52.533 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ForEachNodeListEnumerator9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ForEachNodeListEnumerator.dll 01/07/2007 19:28:52.549 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ForEachSMOEnumerator9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ForEachSMOEnumerator.dll 01/07/2007 19:28:52.564 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32DTEParseMgd9.0.242.0__89845dcd8080cc91DTEParseMgd.dll 01/07/2007 19:28:52.580 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32DTEParseMgd9.0.242.0__89845dcd8080cc91DTEParseMgd.dll 01/07/2007 19:28:52.595 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32DTEParseMgd9.0.242.0__89845dcd8080cc91DTEParseMgd.dll 01/07/2007 19:28:52.595 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinn.90.2047.0 E:MSSQLMSSQLSS2K5DTSBinnDTSComEx.dll 01/07/2007 19:28:52.611 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinndtsmsg.dll 01/07/2007 19:28:52.642 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnDTSLog.dll 01/07/2007 19:28:52.642 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinn.90.2047.0 E:MSSQLMSSQLSS2K5DTSBinnDtsUt.dll 01/07/2007 19:28:52.658 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnDTS.dll 01/07/2007 19:28:52.674 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinn.90.2047.0 E:MSSQLMSSQLSS2K5DTSBinnDTEParsM.dll 01/07/2007 19:28:52.705 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinn.90.2047.0 E:MSSQLMSSQLSS2K5DTSForEachEnumeratorsNodeList.dll 01/07/2007 19:28:52.705 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSForEachEnumeratorsForEachFileEnumerator.dll 01/07/2007 19:28:52.720 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSForEachEnumeratorsForEachFileEnumerator.dll 01/07/2007 19:28:52.736 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSForEachEnumeratorsForEachFileEnumerator.dll 01/07/2007 19:28:52.752 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSForEachEnumeratorsMicrosoft.SqlServer.ForEachSMOEnumerator.dll 01/07/2007 19:28:52.767 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMsDtsSrvr.exe 01/07/2007 19:28:52.783 Failed to read version information for the following file: C:Program FilesMicrosoft.NETADOMD.NETenMicrosoft.AnalysisServices.AdomdClient.xml 01/07/2007 19:28:52.799 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft.NETADOMD.NETMicrosoft.AnalysisServices.AdomdClient.dll 01/07/2007 19:28:52.814 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices.AdomdClient9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.AdomdClient.dll 01/07/2007 19:28:52.830 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedmsasxpress.dll 01/07/2007 19:28:52.845 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedmsasxpress.dll 01/07/2007 19:28:52.861 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedmsasxpress.dll 01/07/2007 19:28:52.877 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5ToolsBinnResources E:MSSQLMSSQLSS2K5ToolsBinnResourcessqlcm.xml 01/07/2007 19:28:52.877 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5ToolsBinnResourcesSqlManager.rll 01/07/2007 19:28:52.908 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5ToolsBinnResourcesSqlManager.rll 01/07/2007 19:28:52.924 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5ToolsBinnResourcesSqlManager.rll 01/07/2007 19:28:52.939 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5ToolsinnSqlManager.dll 01/07/2007 19:28:52.939 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5ToolsinnSqlManager.dll 01/07/2007 19:28:52.970 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5ToolsinnSqlManager.dll 01/07/2007 19:28:52.986 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlsvcsync.dll 01/07/2007 19:28:52.986 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlsvcsync.dll 01/07/2007 19:28:53.002 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlsvcsync.dll 01/07/2007 19:28:53.017 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlsecacctchg.dll 01/07/2007 19:28:53.033 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlsecacctchg.dll 01/07/2007 19:28:53.049 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlsecacctchg.dll 01/07/2007 19:28:53.064 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlftacct.dll 01/07/2007 19:28:53.064 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlftacct.dll 01/07/2007 19:28:53.095 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlftacct.dll 01/07/2007 19:28:53.111 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedisacctchange.dll 01/07/2007 19:28:53.111 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedisacctchange.dll 01/07/2007 19:28:53.127 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedisacctchange.dll 01/07/2007 19:28:53.158 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsvrenumapi.dll 01/07/2007 19:28:53.174 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsvrenumapi.dll 01/07/2007 19:28:53.189 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsvrenumapi.dll 01/07/2007 19:28:53.189 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerShared.90.2047.0 C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Rmo9.0.242.0__89845dcd8080cc91Rmo.dll 01/07/2007 19:28:53.205 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.DLL 01/07/2007 19:28:53.236 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.DataWarehouse.Interfaces9.0.242.0__89845dcd8080cc91Microsoft.DataWarehouse.Interfaces.DLL 01/07/2007 19:28:53.252 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.RegSvrEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.RegSvrEnum.dll 01/07/2007 19:28:53.252 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll 01/07/2007 19:28:53.267 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll 01/07/2007 19:28:53.299 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll 01/07/2007 19:28:53.299 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ServiceBrokerEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ServiceBrokerEnum.dll 01/07/2007 19:28:53.314 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.WmiEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.WmiEnum.dll 01/07/2007 19:28:53.330 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.SqlEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SqlEnum.dll 01/07/2007 19:28:53.345 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.SmoEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SmoEnum.dll 01/07/2007 19:28:53.361 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Smo9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.Smo.dll 01/07/2007 19:28:53.377 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedSqlSAC.exe 01/07/2007 19:28:53.392 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedMicrosoft.SqlSac.Public.dll 01/07/2007 19:28:53.392 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.msxml6_interop6.0.0.0__89845dcd8080cc91Microsoft.SqlServer.msxml6_interop.dll 01/07/2007 19:28:53.517 Attempting to install file: sqlrun_dts.msp 01/07/2007 19:28:53.548 Attempting to install file: \AUS02DB13g$2fe15a257eaedfc36c121fc912HotFixDTSFilessqlrun_dts.msp 01/07/2007 19:28:53.564 Creating MSP install log file at: C:WINDOWSHotfixDTS9LogsDTS9_Hotfix_KB913090_sqlrun_dts.msp.log 01/07/2007 19:28:53.580 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller 01/07/2007 19:28:53.580 Failed to read registry key: Debug 01/07/2007 19:29:48.375 MSP returned 1603: A fatal error occurred during installation. 01/07/2007 19:29:48.672 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller 01/07/2007 19:29:48.687 Failed to read registry key: Debug 01/07/2007 19:29:48.687 Unable to install MSP file: \AUS02DB13g$2fe15a257eaedfc36c121fc912HotFixDTSFilessqlrun_dts.msp 01/07/2007 19:29:48.703 The following exception occurred: Unable to install Windows Installer MSP file Date: 01/07/2007 19:29:48.703 File: depotsqlvaultsetupmainsetupsqlsesqlsedllcopyengine.cpp Line: 856 01/07/2007 19:29:48.750 01/07/2007 19:29:48.765 Product Status Summary: 01/07/2007 19:29:48.781 Product: SQL Server Native Client 01/07/2007 19:29:48.797 SQL Server Native Client (RTM ) - Success 01/07/2007 19:29:48.812 01/07/2007 19:29:48.828 Product: Setup Support Files 01/07/2007 19:29:48.844 Setup Support Files (RTM ) - Success 01/07/2007 19:29:48.844 01/07/2007 19:29:48.859 Product: Database Services 01/07/2007 19:29:48.875 Database Services (SP1 2047 ENU) - Success 01/07/2007 19:29:48.890 01/07/2007 19:29:48.906 Product: Integration Services 01/07/2007 19:29:48.922 Integration Services (SP1 ENU) - Failure 01/07/2007 19:29:48.937 Details: Unable to install Windows Installer MSP file 01/07/2007 19:29:48.953 01/07/2007 19:29:48.969 Product: Client Components 01/07/2007 19:29:48.969 Client Components (SP1 2047 ENU) - Not Applied 01/07/2007 19:29:48.984 01/07/2007 19:29:49.015 Product: MSXML 6.0 Parser 01/07/2007 19:29:49.062 MSXML 6.0 Parser (RTM ) - Not Applied 01/07/2007 19:29:49.078 01/07/2007 19:29:49.094 Product: SQLXML4 01/07/2007 19:29:49.109 SQLXML4 (RTM ) - Not Applied 01/07/2007 19:29:49.109 01/07/2007 19:29:49.140 Product: Backward Compatibility 01/07/2007 19:29:49.156 Backward Compatibility (RTM ) - Not Applied 01/07/2007 19:29:49.156 01/07/2007 19:29:49.172 Product: Microsoft SQL Server VSS Writer 01/07/2007 19:29:49.187 Microsoft SQL Server VSS Writer (RTM ) - Not Applied 01/07/2007 19:29:49.203
DML T-SQL works fine. But When I try to run SELECT query with joins that involves large tables (1.5 mil rows in each) in 2 databases, it instantly goes into "runnable" status and never finishes. It never finishes even when I have top 1 clause included. When I run insert or update that involves same tables, it works just fine.
Server facts:
W2003 SS 2K5 SP2 Db Comp level 90 (for all db) MAXODP = 1 (8 processor box)
Recently moved databases from server that had SS 2000.
When this query was running on box with SS 2000, it took about a minute to finish, but it completed.
I already tried: changing MAXODP settings, using OPTION (maxdop 1) etc.
I have installed SQL Server 2005 Enterprise Edition on a W2K3 server that already has a SQL Server 2000 default instance installed. The installation appears to be a success. The problem is that having installed the client tools, and trying to connect, I get the following error message in a dialog:
"Cannot connect server SERVERNAMEINSTANCENAME 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)(Microsoft SQL Server)"
The funny thing is that I can connect to the SQL Server 2000 default instance that is on that server. So it's obviously not a connection problem per se at my end i.e. bad dns etc which might stop me resolving the server name.
Googling for this error text gives the following advice on various web sites:
1. Check that the remote server allows connections.
It does, as other colleagues in my team have successfully installed the tools and can connect with no problems.
2. Check that the SQL Browser service is running.
It is, as without this running, my colleagues would not be able to connect either.
3. Open SQL Server Configuration Manager. Select "SQL Server 2005 Network Configuration | Protocols for MSSQLSERVER" then enable the protocols you need.
The required protocol (TCP/IP) is enabled. Named pipes is also enabled, although I don't think that we're using that. And shared memory is also enabled by default.
4. Open the firewall and add exceptions for sqlbrowser.exe or UDP port 1434
There is no firewall running at either end of the connection and as mentioned I can connect to the SS2K default instance.
5. Make sure that the server machine is reachable.
I can connect to the SS2K default instance so it must be reachable. I can't see that I would need to change any configuration settings as my colleagues are using exactly the same default settings for their connections and they work fine.
The only thing that I have done differently is that I originally installed the client tools using someone else's privileged account as I didn't have admin rights on my box. The client tools didn't work, so I got admin rights to my box, uninstalled the client tools and then reinstalled them using my account. Still no luck. Not sure if something is still hanging around after the uninstallation that would cause me a problem.
To help, I've also filled out the following questionnaire:
[1] Client side: > What is the connection string in you app or DSN? There isn't one. I'm trying to connect from the SQL Server Management Studio | 'Connect to Server' dialog. > If client fails to connect, what is the client error messages? "Cannot connect server Y 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)(Microsoft SQL Server)" Is the client remote or local to the SQL server machine? Remote Can you ping your server? YES Can you telnet to your SQL Server? YES What is your client database provider? [SNAC | MDAC | ADO.NET1.0 | ADO.NET2.0| other (please specify] N/A What is your client application? SQL Management Studio Is your client computer in the same domain as the Server computer? Different domains What protocol the client enabled? [Shared Memory | TCPIP | Named Pipes]. All 3 protocols are enabled Do you have aliases configured that match the server name portion of your connection string? No Do you select force encryption on server and/or client? No
[2] Server side: What is the MS SQL version? SQL Server 2005 What is the SKU of MS SQL? Enterprise What is the SQL Server Protocol enabled? [Shared Memory | TCPIP | Named Pipes ]. All 3 Does the server start successfully? YES. Other people can connect to the same instance. If SQL Server is a named instance, is the SQL browser enabled? YES What is the account that the SQL Server is running under? Domain Account Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider? N/A. Firewall not running. Do you make firewall exception for SQL Browser UDP port 1434? N/A. Firewall not running. What tool or Application are you using to connect to SQL Server SQL Server Management Studio
[3] Platform: What is the OS version? Windows 2003 (Server side), Windows XP Pro Version 2002 SP 2 Do you have third party antivirus, anti-spareware software installed? Symantec AntiVirus
[4] Misc: If you have certificate configuration issue: N/A
Has anybody else come across this problem, as I've run out of ideas.
I am relatively new to SQL-Server. I was working in a company that used SS2005. Now I am with a company and client where SS2K is my only option. I know SS2005 had Analysis Services which allowed building hypercubes but I never got the chance to learn about it or use it. I am not that familiar with what SS2K has.
I have no access to any OLAP tools. I have MS-Access and MS-Excel. My SQL-Server database has to crunch a table with thousands of rows.
Having worked with MS-Access and MS-Excel for a long time, I know how powerful creating a pivot table is. I heard that SQL2005 had a T-SQL PIVOT function but never had the opportunity to use it.
Know I have the need to do this in SQL2000.
I have a lot of data so the method shown in BOL for cross-tab won't help me. The client changes the "column" and "header" categories on a regular basis, so I need something that will allow me to NOT hard code them but choose them dynamically like one would do in a hypercube.
I have more than 5 categories for "row headers". I have currency for the data to aggregate. I have "pay periods" (26 of them) for my "column" headers, but not all 26 will be present until Dec 31, so that part has to be dynamic.
Question: Is there any feature in the standard S2K that allows one to create anything like a pivot table without massive coding (T-SQL function or technique or something like a hypercube ability)?
Can you point me to something on the web that would explain how to get started?
I would like to know what is the best way to move all the data from a DB to a new database. Some of the tables has different names, and attributes, so is there a way to create a script or something that will do that.
I’m working with an msde database on my local machine, but need to take that database and move it to my remote host. This is problematic because I can not just do a back up and restore. I was wondering if there were any asp.net applications that would generate lots of sql statements to reproduce the database on my remote host. I had built a program to back up all the tables in that way, but, forgot that the membership stuff uses stored procedures, and I don't not know how to modify my program in order to back those up too. Any help will be much appreciated, thank you very much for reading my post
Can someone tell me how to move the log file for a database from one drive to anoyher. I want to keep the data on one drive and the logs on another so I need to move the log files to another drive. Thanx, Kelly
Without restoring the database, has anyone written a slick little piece of code that moves a file existing on on filegroup to another newly created filegroup without doing it from a restore.
The purpose of doing this is to get rid of one data file and placing the data into the data file we are retaining. We have some more physical file space and are moving data into one data file and one transaction log file.
We have already ran the DBCC SHRINKFILE with EMPTYFILE to move the data, We have already ran the ALTER DATABASE statement but here, because the filegroup is identified as PRIMARY in the sysfilegroup table, we can not REMOVE the data file because of indexes relating to the PRIMARY filegroup.
So if I could ALTER DATABASE and create a bogus filegroup and move the data file which I want to get rid of into the bogus filegroup, I could ALTER DATABASE with REMOVE filegroup and solve the situation.
Does anyone know of an easier way to do it other than BACKUP database and RESTORE database.....please help!!!
If you want to move all the databases to new server. Stop the SQL server service on existing server. Copy mdf and ldf files of all databases to same location iin new server. Also take the backup of master and msdb database from existing server. Then restore master and msdb on new server.
"
My question is how to move my database to a DIFFEREN LOCATION on a different server. My two servers are different file layout (not my choice though.)
Thanks a lot in advance.
Wuchun P.S. Should I use the DTS at all to perform this task?
I need your suggestion or experience about how to move a database from SQL 6.5 to SQL 7.0. The server where SQL 6.5 resides locates in different network than SQL 7.0. DTS does not work for the database move because of two server can not talk directly.
We need to do this task very soon in production environment. I tried to backup database to a disk (backup device in SQL 6.5) but I failed to restore it in SQL 7.0 because the backup file was not detected by restore utility in SQL 7.0.
Please tell me what I should do. Besides BCP, are there any other methods to move the database from SQL 6.5 to SQL 7.0 in diffferent networks.
Does anyone know how to move the transaction log(s) of a LIVE database to a new location. I must move the log of a database to a new mirrored drive without any disruption to users. I cannot take the database offline or use the sp_detach_db stored procedure. Your inputs are much appreciated!
I am new to sql server 7 and dont know how to 1.make a copy of a database
and 2 to move a database i know there are sys stored procedures but the syntax looks crptic and i dont know where to type them in if any one could give me any really clear examples of how to do both of the above i would be really grateful, thanks!
Does anyone know how to move tempdb (mdf and ldf files) to another physical disk of already instaled SQL Server 2000? (The idea is to move the tempdb to another dedicated disk in order to improve the performance.)
