Skip to Content

ASE 16.0 set show_trigger_execution on?

Nov 07, 2016 at 01:40 AM


avatar image

"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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mark A Parsons 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).

10 |10000 characters needed characters left characters exceeded