Home > Archive > MS SQL Server > October 2006 > SMTP Stored Procedure









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author SMTP Stored Procedure
Joe K

2006-10-24, 6:38 pm


I have already set up and configured SMTP server. I have a SQL Server 2000
database server, I would like easy stored procedure that I can send alert
messages with this stored procedure.

Thank you very much.
Daniel Jameson

2006-10-24, 6:38 pm

Hi,

I got this to work for me:

http://support.microsoft.com/kb/312839

--
Thank you,

Daniel Jameson
SQL Server DBA
Children's Oncology Group
www. childrensoncologygro
up.org



"Joe K" <Joe K@discussions.microsoft.com> wrote in message
news:96DF466B-4933-4C75-9D10- 92CAF2D60FAD@microso
ft.com...
>
> I have already set up and configured SMTP server. I have a SQL Server
> 2000
> database server, I would like easy stored procedure that I can send alert
> messages with this stored procedure.
>
> Thank you very much.



Arnie Rowland

2006-10-24, 6:38 pm

Check out:

Mail -Sending
SQL 2000 - http://www.sqldev.net/xp/xpsmtp.htm
http://www.aspfaq.com/show.asp?id=2403


--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"Joe K" <Joe K@discussions.microsoft.com> wrote in message
news:96DF466B-4933-4C75-9D10- 92CAF2D60FAD@microso
ft.com...
>
> I have already set up and configured SMTP server. I have a SQL Server
> 2000
> database server, I would like easy stored procedure that I can send alert
> messages with this stored procedure.
>
> Thank you very much.



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com