Triggers BIR

Support for BEFORE and row level triggers is not included in SQL Server 2008.
We realize that BEFORE triggers are extremely useful, specifically in migration scenarios, and are considering this functionality for a future release. Meanwhile, consider using INSTEAD OF triggers to achieve similar functionality.

Row level triggers, though useful in some scenarios, have the potential to significantly impact performance for scenarios where a large number of rows are modified. Having said that, we are actively tracking customer requests for this functionality and we will consider supporting it in a future release.

A request for this functionality has already been filed on connect.microsoft.com here: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=285655&wa=wsignin1.0. If you haven't already done so, please indicate how important this functionality is for you using the 'Rating'.

Thank you.

SaraTahir[MSFT] at 2007-10-2 >