Untitled

sql server trigger to save all user's actions
CREATE  TRIGGER Log_Creators_Modifiers ON Quotation
FOR INSERT,UPDATE AS

  DECLARE
     @ChangeType NVARCHAR
  BEGIN
  /* 'created' for an INSERT, 'Delete' for DELETE, and 'modified' for UPDATE. */
  IF INSERT()
    BEGIN
        SET @ChangeType ='CREATED';
    END

  ELSE IF UPDATE()
    BEGIN
        SET @ChangeType = 'MODIFIED';
    END

  ELSE IF DELETE()
    BEGIN
        SET @ChangeType = 'DELETE';
    END

 END