Is select into Bulk copy and truncate log on checkpoint exclusive?

It seems that within SQL 2005 the settings for Select into/Bulk Copy
and Truncate are mutually exclusive to each other. The only way to set
the option 'Select Into/Bulk Copy' appears to be in the Recovery
Method of the database. Does anyone know if it is possible to set both
select into bulk copy to true, and truncate log on checkpoint to true?Yes, you can set both 'select into/bulkcopy' and 'trunc. log on chkpt' both
to true. This basically sets the database recovery mode to simple. Take a
look at the code of sp_dboption (e.g. sp_helptext sp_dboption) on how these
two options are actually translated into setting the database recovery mode.
Linchi
"CraigOScott@.gmail.com" wrote:
> It seems that within SQL 2005 the settings for Select into/Bulk Copy
> and Truncate are mutually exclusive to each other. The only way to set
> the option 'Select Into/Bulk Copy' appears to be in the Recovery
> Method of the database. Does anyone know if it is possible to set both
> select into bulk copy to true, and truncate log on checkpoint to true?
>|||Hi Linch, in SQL 2005 it appears Microsoft will not support sp_dboption
in future releases. They are saying using simple recovery will apply
truncate log on check point. Using Bulked recovery will apply select
into/Bulk Copy. Is there anyway to select which options you want like
in SQL 2000 or 7?
Linchi Shea wrote:
> Yes, you can set both 'select into/bulkcopy' and 'trunc. log on chkpt' both
> to true. This basically sets the database recovery mode to simple. Take a
> look at the code of sp_dboption (e.g. sp_helptext sp_dboption) on how these
> two options are actually translated into setting the database recovery mode.
> Linchi
> "Craig Scott" wrote:
> > It seems that within SQL 2005 the settings for Select into/Bulk Copy
> > and Truncate are mutually exclusive to each other. The only way to set
> > the option 'Select Into/Bulk Copy' appears to be in the Recovery
> > Method of the database. Does anyone know if it is possible to set both
> > select into bulk copy to true, and truncate log on checkpoint to true?
> >
> >