Get all the available database in SQL Server, using following command.
Following all the command will list all the database on SQL Server.
--In SQL Server 2008
--This is the Stored Procedure which will retrieve database name and size in kb and remark
This stored procedure will retrieve more column then previous sp and return size in mb rather than kb.
And owner of db, created date, and status of the database like status, updatability, useraccessibility etc.
and finally below 2 sps will retrieve detailed information about the database mostly in technical terms.
Technically terms in the sense dbid,status, file path etc.
Select * From sys.databases
Select * From sys.sysdatabases