In several articles about triggers,
Triggers operate quite differently between RDBMS's... if you really want to know about triggers in SQL Server, read about them in Books Online instead of the Web. That'll give you the hot-straight skinny from MS.
--Jeff Moden
Change is inevitable... Change for the better is not.