Use sp_configure with the auditing configuration parameter to enable or disable auditing. 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 10-5.
