SQL @@CONNECTIONS is one of the System Statistical Function, which returns the number of connections since the last time SQL server started. It includes both successful and unsuccessful connections. The syntax behind this is @@CONNECTION is
@@CONNECTIONS
SQL @@CONNECTIONS Example
The below code snippet will show you the total number of connections for this SQL Server.
-- SQL Server @@CONNECTIONS Example SELECT @@CONNECTIONS AS [Total Connections]
OUTPUT
You can use the GETDATE() function along with this function to see the total number of connections until today.
-- SQL Server @@CONNECTIONS Example SELECT @@CONNECTIONS AS [Total Log In Attempts], GETDATE() AS [As of Today]
OUTPUT