I haven't tried changing the default size yet but that's one of the things I'm going to try. When I run sp_spaceused is shows a huge size for tempdb, but...

Thank you both for the advice. I truly, truly appreciate it. I'm keeping an eye on disk space and I think we will be okay until the next normally scheduled...

Everything is up and running now. The only obvious issue is that tempdb won't shrink back down. But otherwise, all operations appear to be normal. This happened early Saturday morning...

First.. I apologize. This is actually regarding SQL Server 2000, not 2005. But this thread was some of the best info I've found so far and everyone here seems to...

I'm having a similar issue.. tempdb.mdf grew to a horrendous size while running a seldom used process. Now I can't get the tempdb.mdf to shrink back down, ever after restarting...