select
[d].[name] [Database Name]
,databasepropertyex( [d].[name], 'COLLATION' ) [Database Collation]
,serverproperty( 'COLLATION' ) [Server Collation]
from [sys].[databases] [d]
where ( databasepropertyex( [d].[name], 'COLLATION' )) != serverproperty( 'COLLATION' );
