【Sybase】You can’t run SELECT INTO in this database的解决办法

    在自建的数据库里执行select into语句的时候失败了,如下: 

    1> select * into users2 from users
    2> go
    Msg 268, Level 16, State 2:
    Line 1:
    You can't run SELECT INTO in this database. Please check with the Database Owner.

    解决办法是设置数据库的select into选项(需要切换到master数据库下进行设置),操作如下: 



    1> use master
    2> go
    1> sp_dboption test ,'select into',true
    2> go
    Database option 'select into/bulkcopy/pllsort' turned ON for database 'test'.
    Running CHECKPOINT on database 'test' for option 'select into/bulkcopy/pllsort' to take effect.
    (return status = 0)
    1> use test
    2> go
    1> checkpoint
    2> go
    1> select * into users2 from users
    2> go
    (2 rows affected)

    搞定。



    本博客所有文章如无特别注明均为原创。
    复制或转载请以超链接形式注明转自枫芸志,原文地址《【Sybase】You can’t run SELECT INTO in this database的解决办法
    标签:
    分享:

还没有人抢沙发呢~

无觅相关文章插件,快速提升流量