Hi,
We ran into an issue where the SQL Server default collation is different from the DB collation - which prevents the Monitoring > Health content checks to be used. The reason is the checks that use INFORMATION_SCHEMA will be on a different collation than the DB. Would it be possible to add COLLATE DATABASE_DEFAULT to these checks?
Example:
SELECT TOP 100 [ItemListId]
FROM [ItemList]
WHERE [ItemListItemType] > ''
AND NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = CONCAT('ItemType_', [ItemListItemType]) COLLATE DATABASE_DEFAULT)
BR Mario