I am using extended stored procedure xp_sendmail to send the email now my
question is, is there any way in can write the out of following query into
one file and send it to through email? or output directly goes to email..

restore FILELISTONLY from disk = 'c:\fullpath.bak'

Thanks

Probably a few ways but a couple off the top of my head -
Execute the command using osql and specify an output file in
the osql command.
Execute the command within a job - for the job step doing
the restore filelistonly, go to the advanced tab and specify
an output file.
You can then send the output file as an attachment using
xp_sendmail.

-Sue

On Mon, 30 Oct 2006 08:20:28 -0500, "Rogers"
<naissani (AT) hotmail (DOT) com> wrote:

Thanks Sue...


"Sue Hoegemeier" <Sue_H (AT) nomail (DOT) please> wrote