SqlServer 08: Query to list all databases in an instance?

Question

How do I list all the databases for a given sql server 08 instance using sqlcmd?

Answer 1

sqlcmd -E -S SERVER\INSTANCE -Q "sp_databases"

Answer 2

EXEC sp_databases

or

SELECT NAME FROM sys.sysdatabases

or

EXEC sp_msForEachDB 'PRINT ''?''';

Answer 3

You can use sp_databases stored procedure.