To turn off database options:
Run sp_helpdb to show the options that are set for each database.
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.
The database options for master cannot
be changed and are not disabled.
