Error message when you run the sp_databases stored procedure in SQL Server 2000: "Arithmetic overflow error converting expression to data type int" (914534)

WORKAROUND

set nocount on
declare @name sysname
declare @SQL  nvarchar(600)

create table #databases (
    DATABASE_ID int NOT NULL,
    size bigint NOT NULL)

declare c1 cursor for 
    select name from master.dbo.sysdatabases
    where has_dbaccess(name) = 1

open c1
fetch c1 into @name

while @@fetch_status >= 0
    begin
        select @SQL = 'insert into #databases select '+
            convert(sysname, db_id(@name)) +
            ', sum(convert(bigint,size)) from ' +
            QuoteName(@name) + '.dbo.sysfiles'
        execute (@SQL)
        fetch c1 into @name
    end

deallocate c1

select  
    DATABASE_NAME = db_name(DATABASE_ID),
    DATABASE_SIZE = convert(bigint,size)*8,
    REMARKS = convert(varchar(254),null)
from #databases
order by 1

drop table #databases