Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DavidChel
Constraint Violating Yak Guru
474 Posts |
 Posted - 2008-08-29 : 14:26:27
|
| I'm trying to set up automatic notifications for my SQL 2000 server. However, I won't be allowed to install Outlook on it. I'm trying to find another way, and I keep seeing xp_sendmail mentioned but I'm having difficulty finding a good article on how to use it. Can it be used in SMTP? Any advice here? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-29 : 14:30:17
|
| http://www.sqlservercentral.com/articles/Advanced+Querying/xp_sendmail/369/ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-29 : 14:31:39
|
| also refer thishttp://www.sqlteam.com/article/sending-smtp-mail-using-a-stored-procedure |
|
|
|
DavidChel
Constraint Violating Yak Guru
474 Posts |
Posted - 2008-08-29 : 14:32:10
|
quote:
Originally posted by visakh16
http://www.sqlservercentral.com/articles/Advanced+Querying/xp_sendmail/369/
As always Visahk, thanks. However, I saw that and also saw this:quote:
Xp_sendmail is a great utility that SQL Server provides in order to e-mail messages directly from SQL Server, by using a valid MAPI profile.
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-30 : 02:07:17
|
| did you refer the second link? |
|
|
|
|
|
|
Sending mail using SQL 2000