Classements différents server/databases

Quelles sont les bases avec un classement différent de celui de l’instance ?

/*-------------------------------------------------------------------
[SCRIPT] Databases_collations  
[DATABASE] master
[DESCRIPTION] Looking for different collations between server and databases
[MAJ PAR] DATAFLY - Arian Papillon
-------------------------------------------------------------------*/
USE master
GO
SELECT SERVERPROPERTY('collation') AS ServerCollation;
-- quelles sont les bases avec un classement différent du serveur
SELECT name
     , DATABASEPROPERTYEX(name, 'collation') AS DBCollation
     , SERVERPROPERTY('collation') AS SRVCollation
FROM   sysdatabases
WHERE  DATABASEPROPERTYEX(name, 'collation') <> SERVERPROPERTY('collation');

/*-------------------------------------------------------------------

[SCRIPT] Databases_collations

[DATABASE] master

[DESCRIPTION] Looking for different collations between server and databases

[MAJ PAR] DATAFLY - Arian Papillon

-------------------------------------------------------------------*/

USE master

SELECT SERVERPROPERTY('collation') AS ServerCollation;

-- quelles sont les bases avec un classement différent du serveur

SELECT name

, DATABASEPROPERTYEX(name, 'collation') AS DBCollation

, SERVERPROPERTY('collation') AS SRVCollation

FROM sysdatabases

WHERE DATABASEPROPERTYEX(name, 'collation') <> SERVERPROPERTY('collation');