Getting List of All Server Databases in MS SQL

The following query should be run to get the list of all databases in the active instance in MS SQL Server.

SELECT Name FROM dbo.sysdatabases

Another method is as follows..

EXEC sp_databases


You May Interest

MS SQL Restoring a Database With a Query

Making a MS SQL Database Offline

What is Central Management in SQL Server ?

What is Extensible Key Management in SQL Server ?

Getting List of MS SQL User-Created Tables