SQL SERVER – List All Database

This is the Stored Procedure which will retrieve database name and size in kb and remark

Exec sp_databases

This stored procedure will retrieve more column then previous sp and return size in mb rather than kb.
And owner of db, created date, and status of the database like status, updatability, useraccessibility etc.

Exec sp_helpdb


Select * From sys.databases