database mail

Question

how to send db mail when database or table is dropped 

Answer 1

Hello,

You can use a DDL trigger to react on a DROP command; in the trigger you could use the system stored procedure sp_send_dbmail (Transact-SQL) to send a SMTP e-mail

---

Olaf Helper

Blog Xing

Answer 2

Thanks