Enabling and disabling auditing

To enable or disable auditing, use sp_configure with the auditing configuration parameter. The syntax is:

sp_configure "auditing", [0 | 1 ]

For example, to enable auditing, enter:

sp_configure "auditing", 1

NoteWhen you enable or disable auditing, Adaptive Server automatically generates an audit record. See event codes 73 and 74 in Table 12-6.