I agree with Allen.  There's no need to backup tempDB as it's recreated every time you restart SQL Server so it's just needless noise to you right now. 

What is...

Sounds to me like defective RAM, especially if the machine returns to normal again after removing it.  Our guys have a tester in house but if you don't have one,...

I don't know if this helps or not, but I've seen something similar in the past when running 7.0.  A few times, when a user would do something wierd I'd start...

This is from the MSDN site:

Thanks...adding the word 'pages' makes the question make more sense.

I would assume the empty pages would remain unless you were to issue a shrink command.

Umm...not sure if I understand.  Truncate table will delete all rows from the table that it is issued on but will preserve the data columns, formatting, constraints and so on. ...

Assuming this is a workstation, have you tried re-installing the client tools?  I can't seem to duplicate this here - mine works fine. 

LOL...the "Do Not Push" button takes you to the EULA.  Not that I acutally pushed it...a friend told me... 

(I subconsciously always wanted to press...

Windo-holics Anonymous?   

You could serve Mountain Dew at the support group meetings instead of coffee. 

M.S. Reddy makes an excellent point.  I have several systems with different credentials for the Production and Development environments.  This forces me to think for an extra moment or two...

My thoughts for what they're worth...

There's two ways of looking at this.  On the one hand, you have 20+ plus accounts to manage.  This means that for instance, if you...

I'm glad that I could be of help and appreciate the comments.  

I think the more you get to know SSC.com the more you'll...

In general I'm somewhat pessimistic regarding reviews as well.  But if you take them with considerable doses of salt, you can usually tell the real from the contrived and can...

The problem is that the local service account does not have rights on the remote machine.  Assuming that you have not removed the Builtin\Administrators account from either server, if you...

Cool, I'll keep my fingers crossed.    I'm pretty confident that the non-existant database was the problem and hopefully you're home free now.