Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Prudence
Starting Member
5 Posts |
 Posted - 2003-02-10 : 01:38:25
|
| Is it advisable to use SQL Notification Services to alert through email the system administrator, or any concerned person for that matter for any insert made on the database table?I am tasked to send notification email if a row is inserted to a certain table with one of its columns acting as flag, containing a value of "0" at an SQL insert. I am thinking of doing this task using triggers instead.Which is a better solution?Thanks. |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-02-10 : 08:17:45
|
| I would personally use triggers as well.Why rely on a flag field ? Triggers are there for this sort of thing.===========Paul |
 |
|
|
|
|
|
I need some advice...