none
Configure mail and send mail sqlserver 2000

    Question

  • hello
    maybe someone knows how to configure script-mail sending in sqlserver 2000, and also how to send mail from sqlserver 2000

    I have the way to configure email sending from 2005 onwards sqlserver, sql 2000 but I have not found ....
    Friday, September 20, 2013 12:55 AM

Answers

  • BOL: INF: How to Configure SQL Mail

    BOL: "An Introduction to SQL Mail and SQLAgentMail

    By Mike Gunderloy

    Making connections between software applications is in style. XML and .NET are just the most visible components of a drive to make everything talk to everything else. We're all in for a lot of learning over the next few years while we figure out how to make our applications work together as Web services. Sometimes, though, it's worth remembering that older technology can still work very well. One such tried and true technology is the connection between Microsoft SQL Server and e-mail.

    SQL Server 2000 and SQL Server 7.0 are fully integrated with e-mail. You can use SQL Server's e-mail integration to perform a variety of tasks:

    • Accept queries via e-mail
    • Send results back via e-mail
    • Notify operators of job success or failure via e-mail or pager

    In this article, you will learn how to set up and use the e-mail services in Microsoft SQL Server 2000. Most of what you'll learn applies equally well to Microsoft SQL Server 7.0. You'll discover that it's actually rather simple to integrate your back-end database with your e-mail system. "

    Link: http://msdn.microsoft.com/en-us/library/office/aa155737(v=office.10).aspx


    Kalman Toth Database & OLAP Architect IPAD SELECT Query Video Tutorial 3.5 Hours
    New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012



    Friday, September 20, 2013 1:06 AM