At the server level, I want to audit privileged users for certain DDL, Security changes, failed logins, etc. At the same time, how can I audit ALL failed logins on the server from any other login? I don't want to audit every other login for DDL, security changes, etc.
Thanks