...
Code Block | ||||
---|---|---|---|---|
| ||||
-- In this example we are using system tables therefore we cannot change the collation sequence of the table itself.
-- We need to override the collation sequence on the actual field comparison
SELECT
sd.DatabaseName
FROM SynDatabases sd
WHERE NOT EXISTS
(
SELECT
*
FROM master.sys.databases md
WHERE md.name = sd.DatabaseName COLLATE DATABASE_DEFAULT
) |
...