declare @out varchar(8000)
declare @From varchar(200)
declare @To varchar(200)
declare @subject varchar(300)
declare @SMTPServer varchar(100)
declare @minimumspace int
set @minimumspace = 15
set @SMTPServer ='MySMTPServer'
set @From ='mak_999@yahoo.com'
set @To ='mak_999@yahoo.com'
set @subject = 'Running out of Hard Disk space on the Server: '+@@servername
exec usp_diskspace @minimumspace,@out OUTPUT
if @OUT is not null or ltrim(rtrim(@OUT))<>'' 
begin
exec usp_send_cdosysmail @From ,@To ,@Subject,@OUT,@SMTPServer
end