Thanks a lot all participates

I Think its easy to follow the last technique which is dividing the process to two parts copy to local hard disk then copy to DVD...

and this is the code which i use:

-- Variable declaration

DECLARE @TableHTML VARCHAR(MAX),

@StrSubject VARCHAR(100),

@Oriserver VARCHAR(100),

@Version VARCHAR(250),

@Edition VARCHAR(100),

@ISClustered VARCHAR(100),

Dirk.Hondong (4/24/2012)

---

Look at the very 1st post.

There is an attachment with the script.

It has an .txt ending.

Regarding the code:

Inside the whole SP, there´s one variable called @TableHTML which...

Dirk.Hondong (4/10/2012)

---

What exactly do you need or in which part of the sproc do you want to declare an additional variable?

alnawrass2002 (4/8/2012)

---

How can i declared a variable at the beginning...

How can i declared a variable at the beginning of the stored procedure, @TableHTML ?

when i try to replace:

xp_sendmail

with

sp_send_dbmail

i got the following error:

The module 'usp_DiskFreeSpaceAlert1' depends on the missing object 'master..sp_send_dbmail'. The module will still be created; however, it cannot run successfully...

Dear all

This is the Stored procedure which i am useing:

------------------------------------------------

USE [master]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[usp_DiskFreeSpaceAlert]

@DriveCBenchmark int = 1024,

@OtherDataDriveBenchmark int = 2048

AS

--By: This procedure sends out an...

Dear all

I run:

select [name] from msdb..sysmail_profile

and the resault is:

Alerts DB Mail

SQL Mail

Dear sir

I configure DB mail and test it and its working fine, but when i run the job i recive the following error:

JOB RUN:'Check Disk Space' was run on 12/7/2011...

Dear antohny

i recive the notifications,but it was:

JOB RUN:'Check Disk Space' was run on 12/7/2011 at 1:00:00 AM

DURATION:0 hours, 0 minutes, 0 seconds

STATUS: Failed

MESSAGES:The job failed. The Job was invoked...

so could you please provide me with the new syntax which will work with SQL Mail ?

Regards

am using sql mail and its working fine,do we need to configure DB mail also.

when i run this SP i receive the following error:

Msg 17938, Level 16, State 0, Line 0

SQL Mail does not work with the 64-bit version of SQL Server

how can i...

Thanks all,i'll go with the script and i'll update you with the results.

Regards

I mean through Graphical user interface without going for scripting or coding.

Thanks & Regards