I have a client running Microsoft SQL Server 2000 RTM. There is no service pack.
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.