I have a client running Microsoft SQL Server 2000 RTM. There is no service pack.
My operating system is Windows 2000 Server;
storage is an old 35 GB hard drive;
partitioned C: at 4 GB (yes, 4) with second partition about 30 GB as data area E drive;
tempdbs are on C: and get up to 2 GB causing problems. C: part is full.
And simply update the machine completely to the new service packs -- this is a no brainer.
View questions and answers from all SQL Server experts here.
This was first published in March 2006