SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
 
-- =============================================
-- Author:      Insus.NET
-- Create date: 2019-05-14
-- Update date: 2019-05-14
-- Description: 数据库空间使用
-- =============================================
CREATE FUNCTION [dbo].[svf_DB_SpaceUsed]()
RETURNS @db TABLE([name] SYSNAME,[physical_name] SYSNAME,[type_desc] SYSNAME,[Size(byte)] bigint)
AS
BEGIN   
    INSERT INTO @db ([name],[physical_name],[type_desc],[Size(byte)]) 
    SELECT [name],[physical_name],[type_desc],SUM(CAST(FILEPROPERTY(name, 'SpaceUsed') AS bigint) * 8192.)  
    FROM sys.database_files    
    GROUP BY [name],[physical_name],[type_desc]
    RETURN
END
 
GO