To determine the current auditing settings for a given option, use sp_displayaudit. The syntax is:
sp_displayaudit [procedure | object | login | database | global | default_object | default_procedure [, name]]
For more information, see sp_displayaudit in Reference Manual: Procedures.
