Here is the code that looks OK to me, but didn't go through: -

DECLARE @Mail_Subject varchar(200), @WorkOrder varchar(15), @PropertyAddress varchar(200)

DECLARE @Attachment_FilePath varchar(200), @FileName varchar(100), @CompanyName varchar(40)

DECLARE @Email_Body varchar(500), @Recipient_Email varchar(100)

DECLARE...

Yes, I did.

Lester Vincent

Yes, I had done that, Cycling Rabbit.:-)

Double-checked before responding to your post to.

Thanks for trying. It still doesn't work from my laptop with Dev Ed 2005.

Would appreciate any...

Thanks heaps for your help so far. I googled the error msg and found a variety of responses. One was that it will only...

I think you are, Mr. Cold Coffee!

Thanks for the code suggestion. Looks good.

Since my post, I tried sending an email from my laptop (using msdb.dbo.sp_send_dbmail, with Developer...

Thanks for replying, mangeshd. Since my post, I have been reading everything I could find on Database Mail, and decided to try it out.

I learned that if...

Thanks Jason. I tried installing the REporting Services Component from my Dev Edition CD but it was not listed among the Components. ...

Thanks Paul. This is a great response to my question!

I have written a VB function in my front-end app which executes a small SPROC to return "SQL"...

Thanks Jason. That is spot-on !!

Much appreciated guys.

I have what I needed now.

Lester Vincent

Sydney

Thanks Hendrico. That is spot-on what I needed!! I can easily build a SPROC around it which searches the returned string for "Express Edition".

Your...

I cannot see how use of Database Mail would be illegal, since it seems to contain exactly the same (Database Mail) system stored procedures as in SQL Server's Enterprise version...

Will do, tonight, Sandy. Again thanks.

Lester Vincent

Thanks Atif. Reckon I'll be able to sort it out from here. Your advice, plus what the other guys have said is most helpful...

Thank you Sandy.

I'll give it a go tonight.

Regards,

Lester Vincent

Thanks Bill.

Referring to your points,

1. and 2. did not happen.     I did not, and never do remove the HDD until all the "lights go out".     The .mdf and .ldf files...