In This Chapter

This chapter covers the following topics on changing the database-logging status:

• Understanding database-logging status
• Modifying database-logging status with ondblog
• Monitoring transaction logging

As a database server administrator, you can alter the logging status of a database as follows:

• Change transaction logging from buffered to unbuffered.
• Change transaction logging from unbuffered to buffered.
• Make a database ANSI compliant.
• Change a table from logging to nonlogging.
• Change a table from nonlogging to logging.

For information about database-logging status, when to use transaction logging, and when to buffer transaction logging, see Logging. To find out the current logging status of a database, see Monitoring Transaction Logging.