Contents Index sp_servercaps system procedure System extended stored procedures

ASA SQL Reference
  System Procedures and Functions
    System and catalog stored procedures

sp_tsql_environment system procedure


Function 

Sets connection options when users connect from jConnect or Open Client applications.

Syntax 

sp_tsql_environment

Permissions 

None

Side effects 

None

See also 

sp_login_environment system procedure

LOGIN_PROCEDURE option [database].

Description 

At startup, sp_login_environment is the default procedure called by the LOGIN_PROCEDURE database option. If the connection uses the TDS communications protocol (that is, if it is an Open Client or jConnect connection), then sp_login_environment in turn calls sp_tsql_environment.

This procedure sets database options so that they are compatible with default Sybase Adaptive Server Enterprise behavior.

If you wish to change the default behavior, it is recommended that you create new procedures and alter your LOGIN_PROCEDURE option to point to these new procedures.

Example 

Contents Index sp_servercaps system procedure System extended stored procedures