-- 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
ALTER LOGIN [sa] ENABLE
GO