Sybase alter table

자료출처 : http://blog.naver.com/skytango?Redirect=Log&logNo=100005088296

 

alter table시 다음과 같은 에러메시지가 나면

 

The 'select into' database option is not enabled for database 'kems'. ALTER
TABLE with data copy cannot be done. Set the 'select into' database option and
re-run.

 

use master

go
sp_dboption DB명 , "select into", true 
go
use DB명

go
checkpoint
go

 

sp_dboption 할 때 다음과 같은 메시지를 보신다면...

The transaction log in database master is almost full. Your transaction is
being suspended until space is made available in the log.

 

.

dump tran master with no_log
go

 

alter table NationVisited  modify orgPriorConsultCnt  int null