SQL users overview
There are a few system functions for returning the number of connections but,they are many times misunderstood. @@CONNECTIONS : Returns login attempts since the server was started.@@MAX_CONNECTIONS: Returns maximum number of connections supported.The simplest way to list all users and processes is to use the system stored procedure: sp_who To list all active users: sp_who…
Read more