Find where DB Collation is different to Server Collation
SELECT @@SERVERNAME AS ServerName , [name] as DBName , SERVERPROPERTY('Collation') AS SvrCollation , DATABASEPROPERTYEX([name],'Collation') AS DBCollation FROM sysdatabases WHERE DATABASEPROPERTYEX([name],'Collation') <> SERVERPROPERTY('Collation')
No comments:
Post a Comment