Get space used per file - 2000

SELECT name,
CAST( ( FILEPROPERTY( name, 'SpaceUsed' ) * 8 )
/ 1024. AS numeric( 10, 2 ) ) as 'SpaceUsed',
CAST( ( size * 8 ) / 1024. AS numeric( 10, 2 ) ) as 'Reserved'
FROM sysfiles