All in one query for tracking changes in sql server Is there any feature in SQL Server 2012 or in any version, wherein I can track all DB activities (DDL and DML) and others in one single query with who has modified and from where and when? I need hostname or IP address as well.

I tried below features which has some limitations


SQL Audit (Unable to track IP)
Event (Unable to track DML operations)
Trace (Unable to track DML operations)


I don't want to use triggers.
I would set up an extended events session to monitor these kind of activities and then review the results of the session from time to time.  You can also set up policies that prevent DDL changes.