Hi guys.

The procedure bellow get the data and log size of all databases in current instance.

CREATE PROCEDURE dbo.uspDatabaseSize
AS
declare
@tbl table (Database_Id int, DataUsedMB Float)

insert into @tbl
exec sp_MSforeachdb
'select db_id(''?'') , (SUM(ps.reserved_page_count)*8)/1024 from ?.sys.dm_db_partition_stats ps';
 
WITH DataSize
AS
(
    select
        DB_ID(d.instance_name)… Read more