The following actions are restricted.
You cannot create #temp tables to use later in the session. Once the procedure completes, #temp tables are automatically dropped and the original session settings are restored, as in any other stored procedure.
Do not use login triggers on the sa login; a failing login trigger can lock you out of Adaptive Server.
Do not use a login trigger for anything that may take longer than a few seconds to process, or that risks processing problems.
