----------

CREATE TABLE pegasus_archive.dbo.SupplierBrandAudit
  (
     auditid  INTEGER IDENTITY(1, 1) PRIMARY KEY,
     [who]    NVARCHAR(300),
     [when]   DATETIME,
     [hidden] BIT
  )

go

CREATE TRIGGER SupplierBrandAuditTrigger
ON pegasus_live.dbo.SupplierBrand
after UPDATE, INSERT
AS
  BEGIN
      INSERT INTO pegasus_archive.dbo.SupplierBrandAudit
                  (who,
                   [when],
                   [hidden])
      SELECT Suser_sname(),
             Getdate(),
             i.[hidden]
      FROM   pegasus_live.dbo.SupplierBrand sb
             INNER JOIN inserted i
                     ON sb.id = i.id
  END

go

------------