Skip to Content

ASE 16.0 set show_trigger_execution on?

"What's New" of ASE 16.0 SP02 introduces "set show_trigger_execution".
-- "set show_trigger_execution prints to the error log the name of the trigger as it is fired, to help you identify where any processing problems are occurring."

It does not work, however.

1> set show_trigger_execution on
2> go
Msg 195, Level 15, State 5:
'show_trigger_execution' is not a recognized option.

Is it ASE bug or document error?

Kazuo Otani

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 07, 2016 at 02:50 AM

    I get the same error in SP02 PL03 and SP02 PL04.

    A search of all the 16.0 manuals I could find shows no matches except for that entry in the What's New manuals.

    At this point I'd say it's a document error; probably a feature/command that was slated for release but for whatever reason never found its way into the codeline; alternatively, maybe it did find its way into the codeline but with a different spelling/name.

    If you've got a support contract you may want to open a case with tech support to see if they can provide a definitive answer (eg, not implemented; implemented but with a different name; to be implemented in the future; etc).

    Add comment
    10|10000 characters needed characters exceeded