Database size (for reporting purposes)

--Database size

CREATE TABLE #tmptb (NAME varchar, db_size varchar (100),
OWNER varchar ($), dbid int,created date,status VARCHAR (500),
Compatibility_level Int,filename VARCHAR (500))

INSERT into #tmptb (name,db_size,owner,dbid,created,status,compatibility_level)
EXEC sp_helpdb

UPDATE #tmptb SET FILENAME = b.filename

From #tmptb a INNER joins master.dbo.sysdatabases b on a.dbid = B.dbid

SELECT name,db_size from #tmptb where dbid >= 5 order BY db_size DESC

DROP TABLE #tmptb