How to list all the databases in SQL Server

To list all the databases in SQL Server 2005 or 2008 use one of the following Stored Procedures:

EXEC sp_databases

or

EXEC sp_helpdb