枫芸志

【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的解决办法》
标签： Sybase
分享：