CREATE TRIGGER (Transact-SQL)

SQL Server allows for multiple triggers to be created for each DML, DDL, or LOGON event. For example, if ...

msdn.microsoft.com