Calculate database space used for a database

on August 5, 2015 at 8:40 am
Posted In: MS SQL Server (Cat)

use dbname

select *, fileproperty(name, ‘SpaceUsed’) as Used From dbo.sysfiles

GO