Enabling or Disabling Event Logging Using sp

You can enable Adaptive Server message storage in the Windows event log by using sp_configure to set the event logging configuration parameter.

Possible values are:

1 – enable logging of Adaptive Server messages:
```
sp_configure "event logging", 1
```
0 – disable logging of Adaptive Server messages:
```
sp_configure "event logging", 0
```

Note: Restart Adaptive Server after enabling logging with sp_configure; disabling does not require a server restart.

For information about the event logging configuration parameter and sp_configure, see the System Administration Guide: Volume 1.

Enabling or Disabling Event Logging Using sp_configure