Michael,

you should use

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

This should have been fixed by one of the 4.x upgrade scripts...

unfortunately it seems as if its not that easy to change the collation of a data-containing DNN-database. When trying to alter it says that it is not possible because of dependencies on the database collation of some objects and functions (fn_split, CK_C5SLLC_form_FromAction,...).

I also tried to add the #PageIndex-table with database collation as described by Sebastian,.. no success either.
FYI, i did this way:
CREATE TABLE #PageIndex
(
IndexID int IDENTITY (1, 1) NOT NULL,
LogGUID varchar(36) COLLATE Latin1_General_CI_AS //<- dnn-database collation
)

is this how it should work?

I'm dragging this thread back to life...

I am getting this errror, my specific one is:

 Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP850_CI_AI" in the equal to operation.

I have done the transact SQL and all the results show SQL_Latin1_General_CP1_C1_AS as the collation on all three.

i tried running the Create #Pageinfo table, however even though the command appears to have completed successfully, I cannot seem to find the new table and the Log Viewer is still broken.

Where should I go from here,,,