Query to find Database Details in SQL Server 2000

Here's the SQL Server 2000 version of the query.
Add columns as per your requirement.

select Name, SUSER_SNAME(owner_sid) as Owner,

[Total Size MB], cmptlevel

from sysdatabases MST inner join (select b.name [LOG_DBNAME],

CONVERT(DECIMAL(10,2), sum(CONVERT(DECIMAL(10,2),(a.size * 8))/1024))

as [Total Size MB] from sysaltfiles A

inner join sysdatabases B on A.dbid= B.dbid

group by b.name)AA on AA.[LOG_DBNAME] = MST.name

order by owner;

MvM