Monday 30 May 2011

Database size calculation

select a.name,rtrim(b.name),rtrim(b.filename),convert(decimal(10,2),((convert(decimal(15,4),b.size) *8192)/1024/1024)) as "Size MB"  from sysdatabases a
left outer join sysaltfiles b on a.dbid=b.dbid

No comments:

Post a Comment