Adaptive Server’s default behavior is to reset any set parameter changes that are set by a trigger or system procedure after they finish running. Enabling set export_options allows you to export the session settings set by a system procedure or trigger to the parent (or issuer) of the stored procedure or trigger.
In this example, Adaptive Server exports set showplan on to outer_proc, but does not exported it to a parent stored procedure:
create proc inner_proc as set showplan on select * from titles set export_options on go create proc outer_proc as exec inner_proc go
