xp send mail

Folks has anybody got a brief on how to implement the email function in sql

I would like to send a email to a super user for instance if a reading from the equipment meterreading is too high

lets say the current equipment meterreading  is 40 ,when a new reading is entered at 455 which is sunstantially more then a email is sent out to a user,the problem I have is that the users get the decimals wrong,thus the reading should be 45.5Can anybody help please

Rutger

rutgermonsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
You have FIRST to configure SQL Mail:
http://support.microsoft.com/?scid=kb%3Ben-us%3B263556&x=9&y=8

Note that you need to follow the steps as described: i.e. configuring the MAPI profile as DOMAIN USER and configure the SQL Server Service AND SQL Server AGENT Service BOTH as the SAME Domain User !!!!

Guy Hengel [angelIII / a3]Billing EngineerCommented:
Once that is done, you can use xp_sendmail stored procedure to send out email...
Please post if you have any specific problems with this
Kevin HillSr. SQL Server DBACommented:
Sucky thing about SQL 2000:

"NOTE: Due to the limitation of only providing extended MAPI support, SQL Server 2000 requires a Microsoft Outlook 2000 client (or later version). "

There are other options that involve using extended sps to communicate through SMTP instead.

I am currently testing:
http://www.sqldev.net/xp/xpsmtp.htm
Guy Hengel [angelIII / a3]Billing EngineerCommented:
Small correction:
Microsoft has confirmed that this is a problem in Microsoft SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.
http://support.microsoft.com/kb/281293/EN-US/

SQL Mail 2000 (SP1+)
works with Microsoft Outlook 98 with the 8.00.0220 SQLMap70.dll. This only applies if Outlook 98 is installed with Microsoft Exchange support (by choosing the Corporate or Email Workgroup Services option), even to connect to a SMTP/POP3 server.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.