Bring all offline databases back online TSQL 2000

bring-online.sql

DECLARE @name VARCHAR(50) -- database name  

DECLARE db_cursor CURSOR FOR  
SELECT name
FROM   master.dbo.sysdatabases
where DATABASEPROPERTYEX(name, 'Status') = 'OFFLINE'
ORDER BY 1

OPEN db_cursor  
FETCH NEXT FROM db_cursor INTO @name

WHILE @@FETCH_STATUS = 0  
BEGIN  
       -- Take the Database Online
EXEC ('ALTER DATABASE ' + @name + ' SET ONLINE;');

       FETCH NEXT FROM db_cursor INTO @name  
END  

CLOSE db_cursor  
DEALLOCATE db_cursor