Sample MS SQL trigger code

CREATE TRIGGER trg_users
ON  dbo.users
FOR  INSERT,UPDATE
AS
BEGIN
    RAISERROR('This is a test', 16, 1)
END
GO