MS SQL: DB size

-- db size
use tempdb
exec sp_spaceused

-- file size
select
sf.groupid,
sf.name,
sf.filename,
((sf.size*8192.0)/1048576) 'MBytes'
from
tempdb.sys.sysfiles sf
order by
sf.groupid,
sf.filename