Software

Ask something
Discussion Locked

Sending mail using sql serv er 7.0

0 helpful
2 replies

by sankarr

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Along the lines of notification services, i wish to know how could I send mails using sqlserver7.0 when a table is updated,etc. I know that i have to use the xp_sendmail for this. I have sqlserver7.0 and ms outlook installed. My machine is coming under a domain controller and mail server is seperate for me. how to create a mail profile in such an environ and use it.????/

2 replies

by glen_mcleod

By using a trigger, every time the table is updated it'll send you an e-mail. You could even specify what columns will result in an e-mail being sent.

Glen

by glen_mcleod

You have to set up SQL Mail. It requires setting up a profile in your e-mail server for the database server's use, then configuring your database server to use the profile. Then you can set up the triggers.

Glen

This discussion is closed to new replies.