yes, for past 2 months..
My bad... It runs on SP4... that was a typo..
SQL SP2 is what I have and Yes, the sql server is dedicated.. I found sqlservr.exe consuming 99% in windows task manager on the windows server.
Background - I support an application which runs on ASP and little bit of .NET and SQL server 2000. Have a separate IIS web and sql server running on...
Separate names with a comma.