I would like to do a calculation on the tempdb file size of my SQL 2000 so that an email could be sent to me if it has reached, for example 80% of the total file size.

sp_tempdbspace provides

database_name database_size spaceused
------------------ ----------------------- ----------------
tempdb 8.750000 .539062

Is there a way to calculate the above? Or is there another sql command to get what I need?

Please advise. Thank you.