• create trigger ServerAuditTrigger

    on all server

    -- Audit server level and database level into dbadata.dbo.ServerAudit

    -- The database level is also audited into <database>.dbo.DatabaseAudit

    with execute as ''server_audit''for ddl_events