Recently I encountered a situation where i have to find out the database file size on SQL Server 2000. Here is the script which you can use to run on SQL Server 2000. Below script will on SQL Server 2005 or SQL Server 2008 as well.
You can use sys.master_files instead of sysAltfiles in SQL Server 2005 and SQL Server 2008. Please find all the different scripts below.
--SQL Server 2000 select fileID ,name ,filename ,(size*8)/1024 SizeMB ,((size*8)/1024)/1024 SizeGB ,db_name(dbid) as DBName from sysaltfiles where db_name(dbid) = 'master' --SQL Server 2000 select fileID ,name ,filename ,(size*8)/1024 SizeMB ,((size*8)/1024)/1024 SizeGB ,db_name(dbid) as DBName from sysaltfiles where filename like '%.ldf%' --SQL Server 2005/2008 SELECT DB_NAME(database_id) AS DBName, Name AS LogicalName, Physical_Name, (size*8)/1024 SizeMB Physical_Name, ((size*8)/1024)/1024 SizeGB FROM sys.master_files WHERE DB_NAME(database_id) = 'Master' GO