Auditar cambios en tu Database

CREATE TRIGGER [NombreDelTrigger]
ON DATABASE
FOR DDL_PROCEDURE_EVENTS, DDL_FUNCTION_EVENTS, DDL_TRIGGER_EVENTS, DDL_TABLE_EVENTS, DDL_VIEW_EVENTS, DDL_INDEX_EVENTS
AS
BEGIN
   INSERT INTO LogTable(fecha,objeto,host,usuario,accion)
   VALUES(GETDATE()
   ,EVENTDATA().value('(/EVENT_INSTANCE/ObjectName)[1]','nvarchar(max)')
   ,HOST_NAME()
   ,SYSTEM_USER
   ,EVENTDATA().value('(/EVENT_INSTANCE/EventType)[1]','nvarchar(max)')
   )
END