Mark can confirm; but, I'd use Enterprise Manger for SQL Server 2000 or Management Studio to alter the stored procedure GetEventLog, changing, this part:

    CREATE TABLE #PageIndex
    (
        IndexID        int IDENTITY (1, 1) NOT NULL,
        LogGUID    varchar(36)
    )

to

    CREATE TABLE #PageIndex
    (
        IndexID        int IDENTITY (1, 1) NOT NULL,
        LogGUID    varchar(36) collate database_default
    )

You should be able to find dbo.EventLog in your DNN database under Stored Procedures (for 2000) and under Programmability (for 2005).  Right click and script Stored Procedure as ALTER (alter so you maintain the permissions).  Make the modification and Execute.

Connect to your DNN database with your DB Management tool of choice and make the modification.

For example, with Enterprise Manager, you'd start EM, select your DNN database, go to Stored Procedures, find the GetEventLog stored procedure and double click on it.  This brings the stored procedure up in an editor.  Find the temp table statement and change the definition of LogGUID to match what I entered above.  Hit the Apply button and go try the event log again.