T-SQL Tutorial

Error messages - TSQL Tutorial


@@Connections TSQL Tutorial

@@Connections is an system statistical function and return the number of connection attempts successful or unsuccessful since SQL Server was last started.

@@Connections Syntax

@@CONNECTIONS;

@@Connections Example

SELECT GETDATE() AS 'Login date',
@@CONNECTIONS AS 'Login id';

Login dateLogin id
2014-01-26 11:47:40.5231921

See also:
T-SQL Functions -> @@MAX_CONNECTIONS