:::: MENU ::::

Get list of all databases through SP_DATABASES

  • May 19 / 2009
  • 0
dbDigger, Monitoring and Analysis, System Stored Procedures

Get list of all databases through SP_DATABASES

While planning to drop many of my test databases, i was tired to write name of all such databases. While looking for any stored procedure to get list of all databases on my SQL Server instance, i found SP_DATABASES. It provided me complete list of databases along with over all size statistics for each.

SP_DATABASES
GO

Get list of all databses on SQL Server instance
From here is copied names of required databases to be dropped.

Consult us to explore the Databases. Contact us