Thanks Sebastian.

It's a bit bigger than the Event Log i think.  i ran this:

SELECT TABLE_NAME, COLUMN_NAME, COLLATION_NAME
FROM INFORMATION_SCHEMA.COLUMNS

and the result was substantial.  Here's a snippet of the CSV file I saved.  All told there are 532 instances of this.

Table Name	Column Name	Collation Name
AllDnn_More_item	Description	SQL_Latin1_General_CP850_CI_AI
AllDnn_More_item	Icon	SQL_Latin1_General_CP850_CI_AI
AllDnn_More_item	Title	SQL_Latin1_General_CP850_CI_AI
AllDnn_More_item	Url	SQL_Latin1_General_CP850_CI_AI
Announcements	Description	SQL_Latin1_General_CP850_CI_AI
Announcements	ImageSource	SQL_Latin1_General_CP850_CI_AI
Announcements	Title	SQL_Latin1_General_CP850_CI_AI
Announcements	URL	SQL_Latin1_General_CP850_CI_AI
AnonymousUsers	UserID	SQL_Latin1_General_CP850_CI_AI
aspnet_Applications	ApplicationName	SQL_Latin1_General_CP850_CI_AI
aspnet_Applications	Description	SQL_Latin1_General_CP850_CI_AI
aspnet_Applications	LoweredApplicationName	SQL_Latin1_General_CP850_CI_AI
aspnet_Membership	Comment	SQL_Latin1_General_CP850_CI_AI
aspnet_Membership	Email	SQL_Latin1_General_CP850_CI_AI
aspnet_Membership	LoweredEmail	SQL_Latin1_General_CP850_CI_AI
aspnet_Membership	MobilePIN	SQL_Latin1_General_CP850_CI_AI
aspnet_Membership	Password	SQL_Latin1_General_CP850_CI_AI
aspnet_Membership	PasswordAnswer	SQL_Latin1_General_CP850_CI_AI
aspnet_Membership	PasswordQuestion	SQL_Latin1_General_CP850_CI_AI
aspnet_Membership	PasswordSalt	SQL_Latin1_General_CP850_CI_AI
aspnet_Profile	PropertyNames	SQL_Latin1_General_CP850_CI_AI
aspnet_Profile	PropertyValuesString	SQL_Latin1_General_CP850_CI_AI
aspnet_Roles	Description	SQL_Latin1_General_CP850_CI_AI
aspnet_Roles	LoweredRoleName	SQL_Latin1_General_CP850_CI_AI
aspnet_Roles	RoleName	SQL_Latin1_General_CP850_CI_AI
aspnet_SchemaVersions	CompatibleSchemaVersion	SQL_Latin1_General_CP850_CI_AI
aspnet_SchemaVersions	Feature	SQL_Latin1_General_CP850_CI_AI
aspnet_Users	LoweredUserName	SQL_Latin1_General_CP850_CI_AI
aspnet_Users	MobileAlias	SQL_Latin1_General_CP850_CI_AI
aspnet_Users	UserName	SQL_Latin1_General_CP850_CI_AI
Assemblies	AssemblyName	SQL_Latin1_General_CP850_CI_AI
Assemblies	Version	SQL_Latin1_General_CP850_CI_AI
Authentication	AuthenticationType	SQL_Latin1_General_CP850_CI_AI
Authentication	LoginControlSrc	SQL_Latin1_General_CP850_CI_AI
Authentication	LogoffControlSrc	SQL_Latin1_General_CP850_CI_AI
Authentication	SettingsControlSrc	SQL_Latin1_General_CP850_CI_AI
Banners	BannerName	SQL_Latin1_General_CP850_CI_AI
Banners	CreatedByUser	SQL_Latin1_General_CP850_CI_AI
Banners	Description	SQL_Latin1_General_CP850_CI_AI
Banners	GroupName	SQL_Latin1_General_CP850_CI_AI
Banners	ImageFile	SQL_Latin1_General_CP850_CI_AI
Banners	URL	SQL_Latin1_General_CP850_CI_AI
Blog_Comments	Email	SQL_Latin1_General_CP850_CI_AI
Blog_Comments	Website	SQL_Latin1_General_CP850_CI_AI
Blog_Entries	Description	SQL_Latin1_General_CP850_CI_AI
Blog_MetaWeblogData	TempInstallUrl	SQL_Latin1_General_CP850_CI_AI
Classification	ClassificationName	SQL_Latin1_General_CP850_CI_AI
Dashboard_Controls	ControllerClass	SQL_Latin1_General_CP850_CI_AI
Dashboard_Controls	DashboardControlKey	SQL_Latin1_General_CP850_CI_AI
Dashboard_Controls	DashboardControlLocalResources	SQL_Latin1_General_CP850_CI_AI
Dashboard_Controls	DashboardControlSrc	SQL_Latin1_General_CP850_CI_AI
DesktopModules	BusinessControllerClass	SQL_Latin1_General_CP850_CI_AI
DesktopModules	CompatibleVersions	SQL_Latin1_General_CP850_CI_AI
DesktopModules	Dependencies	SQL_Latin1_General_CP850_CI_AI
DesktopModules	Description	SQL_Latin1_General_CP850_CI_AI
DesktopModules	FolderName	SQL_Latin1_General_CP850_CI_AI
DesktopModules	FriendlyName	SQL_Latin1_General_CP850_CI_AI
DesktopModules	ModuleName	SQL_Latin1_General_CP850_CI_AI
DesktopModules	Permissions	SQL_Latin1_General_CP850_CI_AI
DesktopModules	Version	SQL_Latin1_General_CP850_CI_AI
Discussion	Body	SQL_Latin1_General_CP850_CI_AI
Discussion	CreatedByUser	SQL_Latin1_General_CP850_CI_AI
Discussion	DisplayOrder	SQL_Latin1_General_CP850_CI_AI
Discussion	Title	SQL_Latin1_General_CP850_CI_AI
Documents	Category	SQL_Latin1_General_CP850_CI_AI
Documents	Description	SQL_Latin1_General_CP850_CI_AI
Documents	Title	SQL_Latin1_General_CP850_CI_AI
Documents	URL	SQL_Latin1_General_CP850_CI_AI
DocumentsSettings	CategoriesListName	SQL_Latin1_General_CP850_CI_AI
DocumentsSettings	DefaultFolder	SQL_Latin1_General_CP850_CI_AI
DocumentsSettings	DisplayColumns	SQL_Latin1_General_CP850_CI_AI
DocumentsSettings	SortOrder	SQL_Latin1_General_CP850_CI_AI
EventLog	LogGUID	SQL_Latin1_General_CP850_CI_AI
EventLog	LogPortalName	SQL_Latin1_General_CP850_CI_AI
EventLog	LogProperties	SQL_Latin1_General_CP850_CI_AI
EventLog	LogServerName	SQL_Latin1_General_CP850_CI_AI
EventLog	LogTypeKey	SQL_Latin1_General_CP850_CI_AI
EventLog	LogUserName	SQL_Latin1_General_CP850_CI_AI
EventLogConfig	LogTypeKey	SQL_Latin1_General_CP850_CI_AI
EventLogConfig	MailFromAddress	SQL_Latin1_General_CP850_CI_AI
EventLogConfig	MailToAddress	SQL_Latin1_General_CP850_CI_AI
EventLogTypes	LogTypeCSSClass	SQL_Latin1_General_CP850_CI_AI
EventLogTypes	LogTypeDescription	SQL_Latin1_General_CP850_CI_AI
EventLogTypes	LogTypeFriendlyName	SQL_Latin1_General_CP850_CI_AI
EventLogTypes	LogTypeKey	SQL_Latin1_General_CP850_CI_AI
EventLogTypes	LogTypeOwner	SQL_Latin1_General_CP850_CI_AI
EventQueue	Attributes	SQL_Latin1_General_CP850_CI_AI
EventQueue	AuthorizedRoles	SQL_Latin1_General_CP850_CI_AI
EventQueue	Body	SQL_Latin1_General_CP850_CI_AI
EventQueue	EventName	SQL_Latin1_General_CP850_CI_AI
EventQueue	ExceptionMessage	SQL_Latin1_General_CP850_CI_AI
EventQueue	ProcessorCommand	SQL_Latin1_General_CP850_CI_AI
EventQueue	ProcessorType	SQL_Latin1_General_CP850_CI_AI
EventQueue	Sender	SQL_Latin1_General_CP850_CI_AI
EventQueue	Subscriber	SQL_Latin1_General_CP850_CI_AI

---

-----
Cheers
Dave

I ran into this issue of the collation last week.  I am doing a DB migration from SQL 2000 to 2008 (not DNN related) and in the process I also have to harden the security of the server.  I use a script I learned some time ago to generate SQL statements that I need to do on many objects and all of a sudden I started getting the error "Cannot resolve collation conflict for column 1 in SELECT statement."   The statement below if a sample of the type of script you can do to generate other SQL statements:

SELECT 'REVOKE ' + RTRIM(p.permission_name) + ' ON ' + '[' + RTRIM(o.name) + '] ' + 'TO ' + RTRIM(u.name)  COLLATE DATABASE_DEFAULT
FROM sys.database_principals u
JOIN sys.database_permissions p ON u.principal_id = p.grantee_principal_id
JOIN sys.all_objects o ON p.major_id = o.object_id
WHERE p.state_desc <> 'DENY'
AND u.name IN ('guest', 'public')
ORDER BY u.name, o.name, p.permission_name

Like I said above, I have used statements like the above a lot without errors until now, in this DB migration, which I did via backup and restore.  I checked the collation of the DB, the tables, and the columns involved and they were all the same.  The problem arises with the concatenation.  It does not matter if you use the N unicode prefix by the way.  The solution is to use COLLATE DATABASE_DEFAULT after the string concatenation like in my sample.  That is the big equalizer, so regardless of what different collations you may be mixing up in your statements (different databases, tables, etc.) the concatenation will be executed using whatever DATABASE_DEFAULT is.  Notice that this is probably the best solution as it solves the problem when you run your query, again, regardless of what the collation is for the tables, etc.  Run the query above with and without the COLLATE DATABASE_DEFAULT to see what happens.

By the way, so far I only ran into this problem when running a statement like the one above where I'm dealing with system tables.  All the queries from the application/user database ran just fine like they were.

By the way #2, run the following query to see the collations available:  SELECT * FROM fn_helpcollations().

Hope this helps (I hope it does, it took me a while to find the solution).  One more thing, when you run the query above you have to be careful of what your current database is, it will obviously give you different results if your current DB is Master versus a user DB.

Carlos