Turn off database options

To turn off database options:

  1. Run sp_helpdb to show the options that are set for each database.

  2. Use sp_dboption and the results from sp_helpdb to turn off all options except select into/bulk copy on tempdb.

    For example, to turn off the trunc log on chkpt database option, enter:

    sp_dboption sybsystemprocs, 'trunc log on chkpt', false

    Turn off the trunc log on chkpt database option to avoid upgrade failure.

For more information about using these system procedures, see the Reference Manual.

NoteThe database options for master cannot be changed and are not disabled.