Don't do that. Install SQL Server 2000 will install MDAC 2.6 which SQL Server 7.0 cluster can't run properly in this MDAC version.

Anyone? Or other ERP applications?

Edited by - allen_cui on 09/26/2003 08:10:09 AM

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_servtools_5cfm.asp

http://support.microsoft.com/default.aspx?scid=kb;en-us;280101&Product=sql2k

Edited by - allen_cui on 09/25/2003 12:56:28 PM

Begin disk performance monitoring by looking at the following counters:PhysicalDisk: Percent Disk Time, PhysicalDisk: Current Disk Queue Length and PhysicalDisk: Avg. Disk Queue Length.

The PhysicalDisk: Percent Disk Time counter monitors...

Check your sysetm variable 'PATH' to make sure SQL Server 2000 executiable path is in front of SQL Server 7.0 programs path.

Any changes on permissions on 'guest' user in TempDB?

Have you tried to upadte database statistics? Can you also look the performance in I/O? You need also start Profiler to see how queries performed in SQL Server.

Try to find out whether it is caused by SQL Server process or by other processes.

Did you remove 'guest' user or block it from TempDB?

active/passive means you have only one SQL Server instance installed. Once install another instance, it becomes active/active.

/PAE is used by OS to use memory beyong 4GB and AWE is used by SQL Server to use memory above 4GB. You need both on if you want to...

You have to enable the logging in your package --> property --> Logging --> Log package execution in SQL Server.

Once you done that, you will be able to see the...

I can't search Microsoft KW because there are some issues seems happening at their KW website. But I have a KB downloaded in my machine and that KB seems match...

Try SP3A from http://www.microsoft.com/sql/downloads/2000/sp3.asp

SP3A or SP3?