Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to send email from SQL server 2000 Expand / Collapse
Author
Message
Posted Tuesday, September 4, 2012 11:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 4, 2012 11:09 PM
Points: 1, Visits: 1
Hi,

I want to send email through store procedure in SQL SERVER 2000. Please help me.
Post #1354324
Posted Wednesday, September 5, 2012 11:04 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 9:14 AM
Points: 9,294, Visits: 9,483
The facility that does this is called "SQLMail", here's the msdn article on how to get started with it: http://msdn.microsoft.com/en-us/library/aa213788(v=SQL.80).aspx.

However, be forewarned: SQLMail requires you to install the Outlook client on the same box as your SQL Server. As MS Outlook is specifically intended to not run on a Server, this can be quite diffcult to get working.


-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #1354765
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse