-- Check version PRINT @@Version SELECT * FROM sys.configurations -- Show all processes SELECT * FROM sys.sysprocesses -- Check active connections SELECT DB_NAME(dbid) AS DBName, COUNT(dbid) AS NumberOfConnections, loginame FROM sys.sysprocesses GROUP BY dbid, loginame ORDER BY DB_NAME(dbid) -- Check Collation used by all databases USE Master GO SELECT NAME, COLLATION_NAME FROM sys.Databases ORDER BY DATABASE_ID ASC GO -- Enable 'sa' login ALTER LOGIN [sa] ENABLE GO