set “Allow select into/bulk copy” option to true without using Sybase Central?

[Avi W.]

Hi All,

How do I set “Allow select into/bulk copy” option to true without using
Sybase Central?

Thanks

[Juergen_Schwindke]

to change the option you have to be in the master-database
use master
go

sp_dboption databasename, "select into/bulkcopy/pllsort", true
go

(for an undo you have to use false instead of true)

after executing that command you have run the checkpoint-command
in the database that was changed

---

you get a list of all options by:
sp_dboption
go

Juergen

[Lyuda Bugriyenko]

Hi,

sp_dboption your_nm_db, "select into/bulkcopy/pllsort", true
use your_nm_db
go
checkpoint

Lyuda.

"Avi W." <av...@hotmail.com> wrote in message
news:4fFEYu7...@forums.sybase.com...

[Avi W.]

Avi W. <av...@hotmail.com> wrote in message
news:4fFEYu7...@forums.sybase.com...