I am searching for way for auditing actions (like logon/logoff, ddl/dml operations, & etc.) of sysadmin role members using internal SQL tools, for it could output audit data to some log file (not ERRORLOG file), not stopping when logging off the MS Windows system.
What i tried already: 1. Login Auditing in Security is not suitable (audits all logins) 2. Creating Audit and Audit Specification - could not get needed result.
Notes: - could not filter audit for sysadmin role members only.(it was succeeded only for sa account) - when view audit logs in Studio> When pressing refresh > the audit file size is increased, which is not rational.
In result - The Audit log file having configured audit events like (like logon/logoff, ddl/dml operations, & etc.) of sysadmin role members. Is it possible to enable?