Getting List of All Server Databases in MS SQL

40 Reads 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
Ms Sql

You May Interest

What are Wait Types in SQL Server ?

Adding Columns to a Table with a Query in MS SQL

MS SQL Compiling a Stored Procedure With a Requery

What is RAISEERROR in SQL Server ?

Changing MS SQL Database Name with Query