SELECT @@servername as ServerName , db_name ( database_id ) as DatabaseName , Name as LogiCalFileName , Physical_Name [Physical file] , ( size * 8 )/ 1024 [Size_MB] FROM sys.master_files...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2007/08/01/1217.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1217" width="1" height="1">