Wednesday, October 19, 2011

Find databases without any owners

SELECT @@SERVERNAME AS ServerName
, [name] as DBName
, SUSER_SNAME(sid) as CurrentDBOwner
FROM sysdatabases
WHERE SUSER_SNAME(sid) is null
OR SUSER_SNAME(sid) = ''

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')