Enable select into in sybase

To enable inserts (i.e. if you want to restore a backup with bcp) you can use sp_dboption as follows:

isql -S SERVER -U USER -PASSWORD
use master
go
sp_dboption DATABASE, "select into", true
go
use DATABASE
go
checkpoint
go

Quote

"It pays to be obvious, especially if you have a reputation for subtlety"
Salvor Hardin, Foundation