Information was omitted from the description for the LOGIN_PROCEDURE option in “Alphabetical list of options,” in Chapter 2, “Database Options,” in the Sybase IQ Reference Manual.
After the sentence, “The customized login procedure must be created in every database you might use,” add the following:
When you set LOGIN_PROCEDURE to call a new procedure, the custom procedure needs to either call sp_login_environment or detect when a TDS connection occurs (see the default sp_login_environment code) and call sp_tsql_environment directly.