Number | Base of difference | Triggers | Event Notifications |
1 | Codes | In triggers we can run T-SQL or CLR codes. | In Event notification we can not run any codes. |
2 | Processes Server | Triggers must be processed on local servers. | When we say about the Event Notification it can be processed on remote servers. |
3 | Scope | Triggers are processed synchronously within the scope of transactions | They are processed asynchronously, not within the scope of transactions |
4 | Events | When we say about the respond in Triggers it will respond to both DML and DLL events.
| Event notification respond to DDL evenets and a subset of SQL trace events.
|