Sets connection options when users log in.
None.
sp_login_environment
At startup, sp_login_environment is called by DBA.sp_iq_process_login, the default procedure called by the LOGIN_PROCEDURE database option.
Sybase recommends that you not edit this procedure. Instead, to change the login environment, set the LOGIN_PROCEDURE option to point to a different procedure.
For more information about setting the LOGIN_PROCEDURE option to the name of a new procedure, see Chapter 15, “Sybase IQ as a Data Server” in the Sybase IQ System Administration Guide.
Here is the text of the sp_login_environment procedure:
CREATE PROCEDURE dbo.sp_login_environment()
BEGIN
IF connection_property('CommProtocol')='TDS' THEN
CALL dbo.sp_tsql_environment()
END IF
END
