kaveer
6/2/2017 - 7:14 AM

Size of database

Size of database

SELECT Db_name()AS       dbname,  
  name      AS     filename,  
  size / 128.0 AS  currentsizemb,  
  size / 128.0 - CAST(Fileproperty(name,'SpaceUsed') AS INT) / 128.0 AS freespacemb  
FROM   sys.database_files