Sending Email via SQL Server

Question

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Martin D. Cymerman SSCrazy Points: 2079 More actions · Answer 1

Yes there is, try using xpsmtp80.dll.

It can be found at:

Marty

SQL Espo SSCrazy Points: 2678 More actions · Answer 2

That is perfect!!!!! One more question,

Is there a way to delete a file sitting on the C drive of the SQL Server through T-SQL?

Thanks,

Michael

Martin D. Cymerman SSCrazy Points: 2079 More actions · Answer 3

I have never used it, however I think there is a procedure: xp_fileexist that might work.

Martin D. Cymerman SSCrazy Points: 2079 More actions · Answer 4

Or else just use xp_cmdshell and specify the network path to your file