How to send the email throught the sql server 2000

Question

Post reply

How to send the email throught the sql server 2000

polo.csit

SSCrazy

Points: 2574
More actions
January 8, 2009 at 3:46 am

#97119

How to send the email throught the sql server 2000

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

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

Johan Bijnens SSC Guru Points: 135368 More actions · Answer 1

polo.csit (1/8/2009)
How to send the email throught the sql server 2000

please post in SQL2000 forum for SQL2000 questions.

Check out sp_sendmail

better even (because it uses smtp mail and no client is needed)

Gerts solution:

http://sqldev.net/xp/sp_smtp_sendmail.htm

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

Old McDonald SSCertifiable Points: 5768 More actions · Answer 2

I beleive sp_sendmail is not available in SQL server 2000. In 2000 you will have to use xp_sendmail.

-Vikas Bindra

Dbs-887309 Old Hand Points: 342 More actions · Answer 3

I remember the procedure EXEC dbo.sp_sendmail.

However, the feature needs to be turned on by the system administrator.

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 4

As vikas bindra pointed out, it is xp_Sendmail. I would recommend you look up the procedure in books online. It requires you configure a MAPI profile on the SQL server.

Johan Bijnens SSC Guru Points: 135368 More actions · Answer 5

vikas bindra (1/8/2009)
I beleive sp_sendmail is not available in SQL server 2000. In 2000 you will have to use xp_sendmail.
-Vikas Bindra

I'm sorry for the typo :blush: ..... didn't use it for years because we went for Gerts solution using smtp.