After you have installed auditing, you can use sp_audit to set auditing options. The syntax for sp_audit is:
sp_audit option, login_name, object_name [,setting]
If you run sp_audit with no parameters, it provides a complete list of the options. For details about sp_audit, see Reference Manual: Procedures.
Auditing does not occur until you activate auditing
for the server. For information on how to start auditing, see “Enabling and disabling auditing”.
