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 |
|
Trojka
Starting Member
10 Posts |
 Posted - 2007-02-28 : 05:34:35
|
I want to monitor updates on a certain table using an alert. When the table gets updated (any update), the alert will trigger a job. Btw, I'm not allowed to add a trigger on the table, hence my idea to use an alert. Somehow I think I should use a WMI event alert, but I'm not sure which server event I should choose. In fact I'm not even sure I shóuld use a WMI event alert.  |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-02-28 : 05:42:00
|
| well you don't have to add a trigger.you can add an event notification.that's a new feature of sql 2005.Look for CREATE EVENT NOTIFICATIONin bol.It uses service broker and it's great.Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
|
|
|
WMI event alert