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.
Dig Deeper on Microsoft SQL Server 2000
Related Q&A from Eric Brown
SQL Server expert Eric Brown provides some helpful resources on business intelligence and data mining in SQL Server 2005. Continue Reading
SQL Server expert Eric Brown helps troubleshoots an issue encountered when exporting to Excel. Continue Reading
SQL Server expert Eric Brown explains the pros and cons of data warehousing. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.