SQL Server: List all the databases

Lists databases that either reside in an instance of the SQL Server 2005 Database Engine or are accessible through a database gateway.



EXEC sp_databases

or,

SELECT name

FROM sys.databases