The following SQL Query provide list of databases: SELECT name, database_id, create_dateFROM sys.databases;GO See also the Microsoft documentation for View list of databases on SQL Server

The following SQL Query provide list of active connections. SELECTDB_NAME(dbid) as DBName,COUNT(dbid) as NumberOfConnections,loginame as LoginNameFROMsys.sysprocessesWHEREdbid > 0GROUP BYdbid, loginame; See also the Microsoft documentation for sys.sysprocesses.