An application may negotiate or renegotiate several issues with a client at any point during the time the server is up and running. Ad hoc negotiations take place inside a SRV_LANGUAGE event handler or a SRV_OPTION event handler. A client may:
Renegotiate the character set and national language through either a Transact-SQL language command or an option command.
Determine aspects of query processing behavior through a Transact-SQL language command or an option command. Clients can request that options be set or cleared, as well as requesting the current status of a particular option.
For a discussion of the SRV_OPTION event and a list of options, see “Options”.
“International support” covers negotiation of national language and character set in detail.
See the Adaptive Server Enterprise Reference Manual and “Security services”.