Insert_BulkCopy Options

--http://manuals.sybase.com/onlinebooks/group-as/asg1250e/svrtsg/@Generic__BookTextView/40676;pt=40842


Error: Unable to Set the BulkCopy Option to disable logging

Turn On select into/bulkcopy (all versions)
Use the sp_dboption stored procedure to set the select into/ bulkcopy option to true:

1--To display into/bulkcopy option.
sp_dboption DB_NAME, "select into/bulkcopy"

2--To enable the TRUE/FALSE option for into/bulkcopy option
sp_dboption DB_NAME, "select into/bulkcopy", TRUE

3.--
use database_name
go

4.--
checkpoint
go

Once a minimally logged operation such as "fast" bulk copy runs in the database, you are not allowed to dump the transaction log to a device, because unlogged changes are not recoverable. Instead, you should do a dump database as soon as possible to restore recoverability and allow transaction dumps to devices again.



http://www.cisco.com/en/US/products/sw/custcosw/ps1001/products_tech_note09186a0080094997.shtml
http://www.mssqltips.com/sqlservertutorial/5/sql-server-bulklogged-recovery-model/