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

最新推荐文章于 2023-01-13 11:46:11 发布

沉稳的格子

最新推荐文章于 2023-01-13 11:46:11 发布

阅读量207

点赞数

分类专栏： Sybase 文章标签：数据库

本文链接：https://blog.csdn.net/farm28/article/details/84373422

版权

Sybase 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

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>