Adaptive Server 15.0.2 introduces the @@lastlogindate global variable.
Global variable | Description |
---|---|
@@lastlogindate |
Global T-SQL variable @@lastlogindate is available to each user login session. A datetime datatype, its value is the lastlogindate column for the login account before the current session was established. This variable is specific to each login session and can be used by that session to determine the previous login to the account. If the account has not been used previously or “sp_passwordpolicy 'set', enable last login updates” is 0, then the value of @@lastlogindate is NULL. |
Global variable | Description of change |
---|---|
@@opttimeoutlimit |
Previous version of Adaptive Server user documenation listed @@opttimeout as a server global variable that displays the current optimization timeout limit for query optimization. This is incorrect. The actual name of the global variable that displays the current optimization timeout limit for query optimization is @@opttimeoutlimit |