Audit database changes

Create Audit

USE master;
GO
CREATE SERVER AUDIT ServerAudit
TO FILE (FILEPATH = 'd:\audits\', MAXSIZE = 2 GB)
WITH (ON_FAILURE = CONTINUE);
GO
ALTER SERVER AUDIT ServerAudit
WITH (STATE = ON);

Affect your database

USE [FIELDPRO_DEMO_SQL_V8];
GO
CREATE DATABASE AUDIT SPECIFICATION schema_change
FOR SERVER AUDIT ServerAudit
ADD (SCHEMA_OBJECT_CHANGE_GROUP)
WITH (STATE = ON);
GO

Preview Changes

SELECT
       event_time AS [Time],
       server_principal_name AS [User],
       object_name AS [Object name],
       Statement
  FROM sys.fn_get_audit_file('d:\audits\ServerAudit*', NULL, NULL)