Thanks Gift...I'm actually looking for some classroom T-SQL for this person. This person does not need SQL Admin training and I feel it is important that he learn in...

Christian, your assessment is correct.  For those interested, the characteristics that Christian refers to regarding the "DBA set status" can be found in the sysaltfiles table.

Eric

For those interested, another forum generated this KB article that I had missed.

307487 - HOW TO: Shrink the Tempdb...

Actually, it recreates the tempdb with the same size it last was.  In a test, I stopped SQL, removed the tempdb data and log files and restarted the server.  The...