SQL 2000 Query Help Please!!

I am new to SQl tranasactions and I'm currently trying to write an SP that will check the database sizes and print the error to the windows eventlogs so that MOM can monitor them. I do not wish to retain the information so I am using a temp table. which once this is written to the logs will be dropped, I also want it to loop though all the databases except for exemption list. SQL 2000 query (hope I'm not completely going in the wrong direction)


SET NOCOUNT ON

DECLARE @size int
DECLARE @name AS sysname
DECLARE @string varchar(1000)
--DECLARE @query varchar(2000)


CREATE TABLE ##temp
(DBNAME varchar(1000),
DBsize int)

SET @Name = ''

---Loop
WHILE 1=1
BEGIN

-- Check all databases except exemption list

SET @Name = (SELECT TOP 1 name
FROM master..sysdatabases
WHERE -- exemption list
NAME NOT IN ('master', 'tempdb', 'model', 'msdb') and
NAME > @Name
)

--SET @name = 'DBA'


SET @string = 'INSERT INTO ##temp (sum([size]) as [size])' + @name + '.dbo.sysfiles'
--SET @string = 'select sum([size]) as [size] into ##temp from ' + @name + '.dbo.sysfiles' --(I REALISE THAT THIS ---------WAS TRYING TO CREATE THE TEMP TABLE FOR EACH DATABASE)
EXEC (@string)
SELECT (@string)

SELECT @size = DBsize from ##temp

-- once done all dbs then get out
IF @Name IS NULL
BREAK

END

DROP TABLE ##temp
--
--Raise error inputs to Eventlog
RAISERROR ('Database size %s is %i', 10, 2, @name, @size ) with log
SELECT @size



I would welcome any help from someone on amending this query or indeed showing me a best practice way of doing this.Thank you inadvance to everyone that reply€™s :-)