To enable or disable auditing, use sp_configure with the auditing configuration parameter. The syntax is:
sp_configure "auditing", [0 | 1 ]
1 – enables auditing
0 – disables auditing
For example, to enable auditing, enter:
sp_configure "auditing", 1
When you enable or disable auditing, Adaptive Server
automatically generates an audit record. See event codes 73 and
74 in Table 11-6.
