Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQLMail
- Thread starter SQLServer
- Start date
Here is an example from SQL Server's BOL:<br><br><FONT FACE=monospace>USE pubs<br>IF EXISTS (SELECT name FROM sysobjects<br> WHERE name = 'reminder' AND type = 'TR')<br> DROP TRIGGER reminder<br>GO<br>CREATE TRIGGER reminder<br>ON titles<br>FOR INSERT, UPDATE, DELETE <br>AS<br> EXEC master..xp_sendmail 'MaryM', <br> 'Don''t forget to print a report for the distributors.'<br><br>GO<br><br></font><br> <p>Robert Bradley<br><a href=mailto: > </a><br><a href= - Visual FoxPro Development</a><br>
- Status
Similar threads
- Locked
- Question