To turn off database options:
Run the sp_helpdb stored procedure to show the options that are set for each database.
Use the sp_dboption stored procedure 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
Be sure to 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.
