Is there any advantage in utilising the AWE switch and maximise on 2.8

We have since updated to SP4 but with little effect on the excessive CPU

It is a dedicated Server replicating data to another Cluster server.

The major application hogging the system is a .net sqlclient data provider @ 140k CPU

Thanks for the reply...

Would 2.8Gb and 1Gb translate into modifying the SQL Server 2000 memory settings to 2.8Gb max and 1Gb min

Thanks again for keeping me informed...

I have been been misleading myself. I thought that setting up a DTS with a connection and a defined Excel file via a view would...

Thanks to both of you...

I have already adopted the New Database Query method on previous project and this has worked well.

The reason for doing it the DTS method is that...

Thanks rudy

Brilliant - I'll shall apply a scheduled task to all our SQL Servers on a period base

Fixed the problem...All down to not having NetBios installed on server. Once installed SQLServerAgent started without a problem. Now to schedule all the windows updates NT6a, hotfixes and reinstall the...

Additional Info: Error 2186: The SAervice is not responding to the control function