...
Code Block | ||||
---|---|---|---|---|
| ||||
-- inIn this example we are using system tables therefore we cannot change the collation seqsequence 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 ) |
...