Posted In: SQL Query to show list of all databases

SQL SERVER – List all the database

EXEC sp_databasesEXEC sp_helpdb ----SQL 2000 Method still works in SQL Server 2005SELECT nameFROM sys.databasesSELECT nameFROM sys.sysdatabases ----SQL SERVER Un-Documented ProcedureEXEC sp_msForEachDB 'PRINT ''?'''

This Article is TAGGED in How to list all databases in SQL Server, How to see list of all database, PL/SQL to show list of all databases, Show list of all databases in SQL Server, SQL Query to show list of all databases. Read more