Found the solution in this post:

http://www.dotnetnuke.com/Community/ForumsDotNetNuke/tabid/795/forumid/108/threadid/63942/threadpage/2/scope/posts/Default.aspx
Thanks go to Cornez who found the solution

The solution is to go in the Stored Procedure : GetEventLog

and to change this part

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

by

CREATE TABLE #PageIndex
(
IndexID int IDENTITY (1, 1) NOT NULL,
LogGUID varchar(36) collate database_default You need to add this in then save the db
)

You should be able to find dbo.EventLog in your DNN database under Stored Procedures (for 2000) and under Programmability (for 2005). Make the modification and Execute.


Now it works for me ... I do not get any more problem with the log table ....

Good luck.