SQL Server 7.0 Service Pack #4 running on Windows 2000 Server
What happens, almost daily is that sp_prepare is running causing the CPU utilization to go over 90+%. On average the CPU is uitlized in the range of 20%-30%.
What is causing the sp_prepare to run, as we do not trigger it. It runs against our db and not the master.
Can somone explain me what is going on and what can be done to resolve it.