How can I get all the database names in a sql server instance using tsql?

Question

How can I get all the database names in a sql server instance using tsql?

Answer 1

SELECT * FROM sys.databases 

Answer 2

----SQL SERVER 2005 System Procedures

EXEC sp_databases EXEC sp_helpdb 

----SQL 2000 Method still works in SQL Server 2005

SELECT name FROM sys.databases SELECT name FROM sys.sysdatabases 

----SQL SERVER Un-Documented Procedure

EXEC sp_msForEachDB 'PRINT ''?''' 

to know more about database : http://blog.sqlauthority.com/2007/05/12/sql-server-2005-list-all-the-database/