June 2, 2011 at 9:04 am
Hi,
I have some servers (SQL Server 2000 servers) their OS is W2k3.
I need that this servers run some jobs and at the end they send e-mails to a list of e-mail that i have.
Do i need to install outlook so that SQL Server can send mails?
Isn't there any script that can send mails without have to install outlook on the database servers?
Thank you
June 2, 2011 at 12:33 pm
Check this out:
June 3, 2011 at 2:34 am
hum... i think that it is only possible if you use outlook.
I was thinking that i could use a stored procedure to send e-mails without having to install outlook on my servers....
Maybe i will not use e-mail because of this...
June 3, 2011 at 2:44 am
we have been using Gert Drapers smtp proc on our sql2000 instances for years. No outlook client needed !
Have a look at http://www.sqldev.net/downloads/default.html
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 3, 2011 at 3:53 am
hum...
That's the link? inside that link there are several other links...
Can you give me the direct link?
Thank you
June 3, 2011 at 4:56 am
It has 4 links:
?downloads/xpsmtp/xpsmtp80-v1.1.0.8.zip
?downloads/xpsmtp/xpsmtp70-v1.1.0.8.zip
?downloads/xpsmtp/sp_smtp_sendmail.sql
?downloads/xpsmtp/xp_sendmail.sql
Which of them it's the one?
June 3, 2011 at 8:39 am
Please read the description and pick the one that suites you best.
http://www.sqldev.net/downloads/xpsmtp/default.html
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 3, 2011 at 9:17 am
As a side note, we also have Mr. Drapers to thank for the Database Mail component in SQL 2005 and above.
CEWII
June 3, 2011 at 9:32 am
🙂 the problem is taht i don't know what is the better for me.
I have SQL Server 2000 and i need that a job send an e-mail every time it fails reporting the status.
I would like to put the list of e-mails to where the infromation would be sent and then the job only nedds to send the e-mail by calling a procedure.
What is the better link for this?
June 3, 2011 at 9:45 am
river1 (6/3/2011)
🙂 the problem is taht i don't know what is the better for me.I have SQL Server 2000 and i need that a job send an e-mail every time it fails reporting the status.
I would like to put the list of e-mails to where the infromation would be sent and then the job only nedds to send the e-mail by calling a procedure.
What is the better link for this?
FWIW Test them all !
They are all pretty stable for usage.
Just bouble check you are using them correct.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply