/*

I MADE MY WORK FOR DATABASE THAT HAS ANY NUMBER OF DATA OR LOG FILES

*/

SET QUOTED_IDENTIFIER ON

set nocount on

DECLARE @dbsize     decimal,

 @dbmaxsize     decimal,

 @DatabaseSize nvarchar(100),

 @DatabaseName CURSOR,

 @dbname nvarchar(100),

 @SQLString nvarchar(500),

        @MyEmailMessage varchar(500),

        @dbfilename varchar(100)

CREATE TABLE...

I have wrote some thing like this

/*

script 1

*/

SET QUOTED_IDENTIFIER ON

set nocount on

DECLARE

@dbsize int,

@dbmaxsize

int,

@DatabaseSize...

Const HARD_DISK = 3

strComputer = "."

Set objWMIService = GetObject("winmgmts:" _

& "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")

Set colDisks = objWMIService.ExecQuery _

("SELECT * FROM Win32_LogicalDisk...