SQL Server Audit Fields

created_at: Use the following syntax for the default value getdate()
created_by you can Use the following syntax for the default value: user_name()+'|'+suser_sname()

Update Triggers


			CREATE TRIGGER updateModified
ON KPI_KPIDaily_daily_data_xlsm.machine
AFTER UPDATE
AS
   UPDATE KPI_KPIDaily_daily_data_xlsm.machine
   SET machine.updated_at = SYSDATETIME()
     , machine.updated_by = CURRENT_USER + '|' + system_user
   FROM Inserted AS i
   WHERE KPI_KPIDaily_daily_data_xlsm.machine.stat_code = i.stat_code;