`
winnie825
  • 浏览: 120206 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

The 'select into' database option is not enabled for database ***

 
阅读更多

在sybase进行列更新语句时,可能会遇到这样的错误

无法执行语句。
The 'select into' database option is not enabled for database '#TABLE_NAME#'.
ALTER TABLE with data copy cannot be done. Set the 'select into'
database option and re-run.
Sybase 错误代码=11052
Severity Level=16, State=1, Transaction State=1
第 2 行

alter table #TABLE_NAME# modify #COLUM# varchar(100)

 

错误产生的原因是sybase数据库没有赋予当前库执行select into的权限,修改方法有两种:

1. 如果仅是偶尔执行alert语句,可以先执行以下sql:

use master
go
exec sp_dboption '#DB_NAME#', 'select into', 'TRUE'
go

 2. 修改数据实例属性,赋予select into等权限:



 

  • 大小: 71.2 KB
分享到:
评论

相关推荐

    端口查看工具

    o The 'Use DNS Cache For Host Names' option is now turned off by default, because it seems that reading the DNS cache causes a memory leak on some Windows 7/x64 systems. * Version 1.96: o Fixed ...

    微软内部资料-SQL性能优化2

    The boot.ini option /3GB was created for those cases where systems actually support greater than 2 GB of physical memory and an application can make use of it This capability allows memory intensive ...

    CE中文版-启点CE过NP中文.exe

    Address List: When the option to deactivate children is set, the children will get deactivated first Memory Scan: Add a lua script in autorun that lets you specify which module to scan Lua: ...

    php.ini-development

    Note: This directive is hardcoded to Off for the CLI SAPI ; Default Value: Off ; Development Value: 4096 ; Production Value: 4096 ; http://php.net/output-buffering output_buffering = 4096 ; You can ...

    EurekaLog_7.5.0.0_Enterprise

    6)....Added: Use ShellExecute option for mailto send method 7)....Added: "Mandatory e-mail only when sending" option 8)....Added: Exception line highlighting in disassember view in EurekaLog exception...

    XDA成员开发出Carrier IQ检测程序(Android)

    Logging Test App v7 ...Shows on stock rom regardless of tell HTC or location setting logging is enabled and running, proving HTCs statement wrong, wasting resources, io, memory, bandwidth the works - ...

    oracle学习文档 笔记 全面 深刻 详细 通俗易懂 doc word格式 清晰 连接字符串

     删除HKDY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI中除Microsoft ODBC for Oracle注册表键以外的所有含有Oracle的键。  删除环境变量中的PATHT CLASSPATH中包含Oracle的值。  删除“开始”/“程序”中所有...

    物业管理系统

    ‘ndialogtype=4+32nAnswer=messagebox(cmessagetext,ndialogtype,cmessagetitle)do case case nAnswer=6 i=1 for i=cstart to cend xqno=alltrim(str(i)) select *; from databasewuyemanage!tabxqinfo; where 小区...

    Visual Basic 6编程技术大全 中译本扫描版带书签 2/2

    2.1.6 Enabled和Visible属性25 2.1.7 hWnd属性26 2.1.8 TabStop和Tablndex属性26 2.1.9 MousePointer和Mouselcon属性27 2.1.10Tag属性28 2.1.11其他属性28 2.2 通用方法29 2.2.1 Move方法29 2.2.2 Refresh方法30 ...

    Visual Basic 6编程技术大全 中译本扫描版带书签 1/2

    2.1.6 Enabled和Visible属性25 2.1.7 hWnd属性26 2.1.8 TabStop和Tablndex属性26 2.1.9 MousePointer和Mouselcon属性27 2.1.10Tag属性28 2.1.11其他属性28 2.2 通用方法29 2.2.1 Move方法29 2.2.2 Refresh方法30 ...

Global site tag (gtag.js) - Google Analytics