Using sp_configure

You can enable Adaptive Server message storage in the NT event log by using sp_configure to set the event logging configuration parameter. Possible values are:

NoteRestart 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 in general, see the System Administration Guide.