USE CeilInn4;
GO

--========================================================
--Database :    CeilInn4
--DML Trigger : RecordInsertion
--Description : This trigger updates the DatabaseOperations
--              by letting it know that a new record was
--              added to the Rooms table. The trigger
--              specifies the name of the employee
--              who performed the operation and the time
--              this occurred
--========================================================

CREATE TRIGGER RecordInsertion
ON Rooms
AFTER INSERT
AS
BEGIN
    INSERT INTO DatabaseOperations
VALUES(N'Table', N'Rooms', SUSER_SNAME(),
       N'Created a new record', GETDATE())
END
GO