SQL retrieve data in database and send via email

Last Post 06 May 2009 12:40 AM by DarkAngle. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
DarkAngle
New Member
New Member

--
04 May 2009 06:00 PM
Hi,
I'm trying to get some data from SQL 2000 database and send it thru email.
Anyone got the idea how to do it? I'm tried several method but it seem like cant work.
DarkAngle
New Member
New Member

--
06 May 2009 12:40 AM
quote:

Originally posted by: gunneyk
I used this xp for a while on 2000 and it always worked great.
http://www.sqldev.net/xp/xpsmtp.htm



As i know this only able to send job notification, schedule, email attachment etc. But how about if i wan get some specific data in database and send it out?
PS : the data i wan get actually is alarm data, mean that when there is alarm occur, it will send to my email.

Thanks

DarkAngle
New Member
New Member

--
13 May 2009 11:26 PM
quote:

Originally posted by: rm
You can call it in sql script. In your case, may need trigger to send mail.


Hi, i try to use trigger and stored procedure when there is any update of data, it will send me a notification mail. But i dun have any idea how to include the database's data into the mail.

shijobaby
New Member
New Member

--
28 Dec 2009 06:01 AM
You are not authorized to post a reply.

Acceptable Use Policy