The following actions are restricted.
You cannot use a login trigger to set session-specific options, such as set nocount on, set rowcount on, and so on. Setting session options in any stored procedure has an effect only inside that stored procedure.
You cannot create #temp tables to use later in the session. Once the procedure completes, the #temp tables drop away automatically and the original session settings are restored, as in any other stored procedure.
You should 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.
