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.