[转]You cannot run the non-logged version of bulk copy in this database. Please c

sybase@CHQ_WEB:/sybase/OCS-12_5/bin > dbrestore
*** 0+1/1 bcpout chuanpiao ***
Server Message: CHQ_WEB - Msg 4806, Level 16, State 1:
You cannot run the non-logged version of bulk copy in this database. Please check with the DBO.

CTLIB Message:  - L0/O0/S0/N0/0/0:
blk_init(): blk layer: CT library error: Failed when CT_Lib routine ct_results() called.
blk_init failed.
*** chuanpiao done ***n

解决方法如下:

使用isql

1> use master
2> go
1> sp_dboption cqweb,"select into/bulkcopy",true
2> go
Database option 'select into/bulkcopy/pllsort' turned ON for database 'cqweb'.
Running CHECKPOINT on database 'cqweb' for option 'select into/bulkcopy/pllsort'
to take effect.
(return status = 0)
1> use cqweb
2> go
1> checkpoint
2> go
1>