SQL SERVER – List all the database and Find the Size of Database File – Find the Size of Log File

SQL SERVER - List all the database


EXEC sp_databases
EXEC sp_helpdb

old version

SELECT name
FROM sys.databases
SELECT name
FROM sys.sysdatabases

===================================================

 Find the Size of Database File – Find the Size of Log File



SELECT DB_NAME(database_id) AS DatabaseName,
Name AS Logical_Name,
Physical_Name, (size*8)/1024 SizeMB
FROM sys.master_files
WHERE DB_NAME(database_id) = 'employee'
GO