sp_databases is a system stored procedure which will return all the databases in a SERVER along with the database sizes:

syntax for sp_databases stored procedure is:

  • sp_databases : This will return all databases information.
  • sp_databases <database Name >: This will return only 1 particular Database information.


Following picture represents the database information for all the databases in SQL Server .

This entry was posted in . Bookmark the permalink.

Leave a reply