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

Asked 2010-01-18T17:28:03.613

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

sql-server sql-server-express sqlcmd

Edit Report

1 Answer

EXEC sp_databases

SELECT NAME FROM sys.sysdatabases

EXEC sp_msForEachDB 'PRINT ''?''';

answered 2010-01-18T17:29:31.053