/* DUMP all transaction logs for all SQL company databases */   

DECLARE @CoName varchar(20)
DECLARE Old_dbname CURSOR FOR SELECT db_name FROM COtable
OPEN Old_dbname 
FETCH NEXT FROM Old_dbname INTO @CoName 
WHILE (@@fetch_status <> -1)

	BEGIN
	EXEC ("DUMP TRANSACTION " + @CoName + " WITH TRUNCATE_ONLY")
	END
	FETCH NEXT FROM Old_dbname INTO @CoName 
	END
DEALLOCATE Old_dbname 

this cursor USED to work!
Does anyone know the SQL 2000 version?