Set triggers on/off

[Christian Meggiorin]

Hi everybody,
Who can do "set triggers on/off" ??
Which grants/role are necessary to execute the command "set triggers
off/on" ??
Thank you,
Christian

[ibrahim DOGAN]

* there is no such command ,
you should drop triggers.
* To insert rows into a table without
executing insert trigger, then make bcp.

i.d.

Christian Meggiorin wrote in message ...

[Stefan Goebel]

Hi ibrahim,

ibrahim DOGAN wrote in message <6d8eFlNu$GA....@forums.sybase.com>...

>* there is no such command ,

hmm, there *is* a command set trigger on/off, at least I have tested it and
it
works...

Think you need sso role for it.

Bye, Stefan

[ibrahim DOGAN]

Hello Stefan,

* Sorry, at which ASE version ? I tried it (set trigger on) for 11.5.1 and
it gave error.

bye
i.d.

Stefan Goebel wrote in message <#2M3uSQu$GA....@forums.sybase.com>...

[Stefan Goebel]

Hello Ibrahim,

I tried it as "sa" user on ASE 11.0.3.3 on Linux

Bye, Stefan

ibrahim DOGAN wrote in message ...

[Peter Veilleux]

Stefan,

I'd like to know how you got a copy of 11.0.3.3 for Linux. According to the
web site, the Linux version of ASE wasn't developed until 11.9.2. Regardless,
the command to disable triggers originates in 12.0, at least according to the
books:

"Loading a database from a previous dump causes any triggers defined in the
database to
fire, which can increase the amount of time required to load the database.
Adaptive Server
12 introduces the disable trigger option of the alter table command to disable
any triggers
in a database before you load the database, reducing the time required to load
the database.
Use alter table... enable trigger to re-enable the triggers after the load
database is
complete. alter table... disable trigger uses the following syntax:

alter table [database_name.[owner_name].]table_name
{enable | disable} trigger [trigger_name]"

right from the 12.0 What's New Guide.....

Peter

[Stefan Goebel]

Hi Peter,

ASE 11.0.3.3 was included in our Linux distribution we use, "SuSE"

Bye, Stefan

Peter Veilleux wrote in message <39196764...@nvestservices.com>...